Scaling Postgres Episode 181 Connection Scaling | Cached Sequences | Message Queuing | Harmful Subtransactions

In this episode of Scaling Postgres, we discuss connection scaling, how to cache your sequences, a message queuing implementation and the harms of subtransactions.

Content Discussed

• When Less is More: Database Connection Scaling
• UUID or cached sequences?
• Devious SQL: Message Queuing Using Native PostgreSQL
• PostgreSQL Subtransactions Considered Harmful
• How to create (lots!) of sample time-series data with PostgreSQL generate_series()
• Partitioning use cases with PostgreSQL
• Logical Replication Tablesync Workers
• Solving the knapsack problem in PostgreSQL
• PostgreSQL: The power of a SINGLE missing index
• PostGIS 3.1.4, 3.0.4 Released
• PostGIS upgrade with Ubuntu 20.04.02
• Querying Spatial Data with PostGIS and ogr_fdw
• Identify OpenStreetMap changes with Postgres
• Dmitry Dolgov
• Rubber Duck Dev Show Episode 11 | Modern Web Application Front Ends

YouTube Video