Queuing
From PostgreSQL wiki
(Difference between revisions)
(Queueing in Core) |
|||
| Line 1: | Line 1: | ||
| - | = Queueing in core | + | = Queueing in core = |
Internal use cases: | Internal use cases: | ||
| - | + | * Materialized Views | |
| - | + | * Alter Table Concurrently | |
| - | + | * Cluster Concurrently | |
| - | + | * Parallel queries | |
External use cases: | External use cases: | ||
| - | + | * Very Common Design Pattern | |
| - | + | * Datawarehouse and pruning historical data (avoid vacuum issues) | |
Implementation: | Implementation: | ||
| - | + | * it's a table | |
| - | + | * concurrent inserts and pruning | |
| - | + | * no update | |
| - | + | * payload would be a record/tuple (create type / create table) | |
Revision as of 13:15, 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)
