Queuing

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Queueing in Core)
 
Line 1: Line 1:
= Queueing in core
+
= Queueing in core =
  
 
Internal use cases:
 
Internal use cases:
  
- Materialized Views
+
* Materialized Views
- Alter Table Concurrently
+
* Alter Table Concurrently
- Cluster Concurrently
+
* Cluster Concurrently
- Parallel queries
+
* Parallel queries
  
 
External use cases:
 
External use cases:
  
- Very Common Design Pattern
+
* Very Common Design Pattern
- Datawarehouse and pruning historical data (avoid vacuum issues)
+
* Datawarehouse and pruning historical data (avoid vacuum issues)
  
 
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)

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)
Personal tools