From PostgreSQL wiki

Revision as of 13:19, 16 May 2012 (view source) Dim (Talk | contribs) (→Queueing in core) ← Older edit

Revision as of 13:22, 16 May 2012 (view source) Dim (Talk | contribs) m (moved Queueing to Queuing: Typo.) Newer edit →

---

Revision as of 13:22, 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