Queuing

From PostgreSQL wiki

= 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)