Queuing

From PostgreSQL wiki

Revision as of 16:18, 19 May 2012 by Boshomi (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Queueing in core

Internal use cases:

  • Materialized Views
  • Alter Table Concurrently
  • Cluster Concurrently
  • Parallel queries
  • PG/Strom: GPU Offloading (parallel too)

Parallel queries have different transactional semantics needs (it's all running in the same transaction, producer and consumer)

External use cases:

  • Very Common Design Pattern
  • Datawarehouse and pruning historical data (avoid vacuum issues)

Implementation:

  • it's a table?
  • concurrent inserts and pruning
  • no update
  • payload would be a record/tuple (create type / create table)
  • FIFO, Insert Only Segment Optimisation with a starting block that can be > 0
Personal tools