Scaling Postgres Episode 181 Connection Scaling | Sequence Cache | Message Queuing | Subtransactions

Описание: To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

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

Timestamps:

00:00 - Intro
00:27 - When Less is More: Database Connection Scaling
03:10 - UUID or cached sequences?
05:47 - Devious SQL: Message Queuing Using Native PostgreSQL
08:56 - PostgreSQL Subtransactions Considered Harmful
13:35 - How to create (lots!) of sample time-series data with PostgreSQL generate_series()
15:32 - Partitioning use cases with PostgreSQL
18:57 - Logical Replication Tablesync Workers
19:37 - Solving the knapsack problem in PostgreSQL
20:36 - PostgreSQL: The power of a SINGLE missing index
21:00 - Dmitry Dolgov
21:11 - Rubber Duck Dev Show Episode 11 | Modern Web Application Front Ends
21:32 - Outro

#postgres #postgresql