Queuing
From PostgreSQL wiki
(Difference between revisions)
(→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
