Queuing

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Queueing in core)
Line 15: Line 15:
 
Implementation:
 
Implementation:
  
* it's a table
+
* it's a table?
 
* concurrent inserts and pruning
 
* concurrent inserts and pruning
 
* no update
 
* no update
 
* payload would be a record/tuple (create type / create table)
 
* payload would be a record/tuple (create type / create table)
 +
* FIFO, Insert Only Segment Optimisation with a starting block that can be > 0

Revision as of 13:19, 16 May 2012

Queueing in core

Internal use cases:

  • Materialized Views
  • Alter Table Concurrently
  • Cluster Concurrently
  • Parallel queries

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