Queuing

From PostgreSQL wiki

Revision as of 13:14, 16 May 2012 by Dim (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

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)

Personal tools