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

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