From PostgreSQL wiki

Revision as of 13:15, 16 May 2012 by Dim (Talk | contribs)

Jump to: navigation, search

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)


  • it's a table
  • concurrent inserts and pruning
  • no update
  • payload would be a record/tuple (create type / create table)
Personal tools