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/2021/09/04/postgis-patches/

https://www.cybertec-postgresql.com/en/postgis-upgrade-with-ubuntu-20-04-02/

https://blog.crunchydata.com/blog/querying-spatial-data-with-postgis-and-ogr_fdw

https://blog.rustprooflabs.com/2021/08/postgres-openstreetmap-changes-over-time-json

https://postgresql.life/post/dmitry_dolgov/

https://www.rubberduckdevshow.com/episodes/11-modern-web-application-front-ends/