PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Speakers
Thomas Munro
Schedule
Day Talks - Day 2 - 2016-05-20
Room DMS 1160
Start time 14:00
Duration 00:45
Info
ID 929
Event type Lecture
Track Applications
Language used for presentation English

Queues in PostgreSQL

Can elephants queue?

Many projects involve something resembling job or message queuing. In this talk I will look at:

  • the pros and cons of using a plain old relational database for this type of workload rather than specialized technology
  • approaches and designs
  • special considerations for PostgreSQL
  • performance and tuning
  • potential improvements

Using your existing PostgreSQL cluster to queue jobs and messages can be a reasonable choice in some cases. However, it's not without complications. This talk looks at queue-like workloads in detail. The topics covered will include:

  • defining and categorizing queue-like structures and access patterns
  • reasons to consider building queues inside your relational database
  • reasons to avoid building queues inside your relational database
  • example use cases
  • locking strategies and concurrency
  • higher transactions isolation levels
  • vacuuming considerations and workarounds
  • statistics and indexes
  • benchmarking
  • comparing PostgreSQL to some other RDBMSs
  • some relevant potential future features for PostgreSQL