Scaling Postgres

In this episode of Scaling Postgres, we discuss connection scaling, how to cache your sequences, a message queuing implementation and the harms of subtransactions. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://richyen.com/postgres/2021/09/03/less-is-more-max-connections.html https://dev.to/yugabyte/uuid-or-cached-sequences-42fi https://blog.crunchydata.com/blog/message-queuing-using-native-postgresql https://postgres.ai/blog/20210831-postgresql-subtransactions-considered-harmful https://blog.timescale.com/blog/how-to-create-lots-of-sample-time-series-data-with-postgresql-generate_series/ https://blog.anayrat.info/en/2021/09/01/partitioning-use-cases-with-postgresql/ https://www.postgresql.fastware.com/blog/logical-replication-tablesync-workers https://dev.to/ftisiot/solving-the-knapsack-problem-in-postgresql-40cc https://www.cybertec-postgresql.com/en/postgresql-the-power-of-a-single-missing-index/ http://postgis.net/202