From PostgreSQL wiki

Revision as of 13:23, 16 May 2012 (view source) Dim (Talk | contribs) (→Queueing in core) ← Older edit		Revision as of 13:24, 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	+	* PG/Strom: GPU Offloading (parallel too)
		+
		+	Parallel queries have different transactional semantics needs (it's all running in the same transaction, producer and consumer)
	External use cases:		External use cases:

---

Revision as of 13:24, 16 May 2012

Queueing in core

Internal use cases:

• Materialized Views
• Alter Table Concurrently
• Cluster Concurrently
• Parallel queries
• PG/Strom: GPU Offloading (parallel too)

Parallel queries have different transactional semantics needs (it's all running in the same transaction, producer and consumer)

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