From PostgreSQL wiki

Revision as of 13:22, 16 May 2012 (view source) Dim (Talk | contribs) m (moved Queueing to Queuing: Typo.) ← Older edit		Revision as of 13:23, 16 May 2012 (view source) Dim (Talk | contribs) (→Queueing in core) Newer edit →
Line 7:		Line 7:
	* Cluster Concurrently		* Cluster Concurrently
	* Parallel queries		* Parallel queries
		+	* PG/Strom: GPU Offloading
	External use cases:		External use cases:

---

Revision as of 13:23, 16 May 2012

Queueing in core

Internal use cases:

• Materialized Views
• Alter Table Concurrently
• Cluster Concurrently
• Parallel queries
• PG/Strom: GPU Offloading

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