In this episode of Scaling Postgres, we discuss 5 years of scaling lessons, working with synchronous commit, managing connections and cleaning up BLOBs.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://onesignal.com/blog/lessons-learned-from-5-years-of-scaling-postgresql/

https://momjian.us/main/blogs/pgblog/2021.html#April_14_2021

https://blog.crunchydata.com/blog/your-guide-to-connection-management-in-postgres

https://www.cybertec-postgresql.com/en/cleaning-up-large-number-blobs/

https://www.keithf4.com/managing-transaction-id-exhaustion-wraparound-in-postgresql/

https://blog.crunchydata.com/blog/postgres-is-out-of-disk-and-how-to-recover-the-dos-and-donts

https://www.cybertec-postgresql.com/en/finally-a-system-level-read-all-data-role-for-postgresql/

https://www.citusdata.com/blog/2021/04/10/talk-at-cmu-how-citus-distributes-postgresql-via-extension-apis/

https://www.enterprisedb.com/blog/benchmarking-postgresql-setting-raid-array-scratch

https://www.highgo.ca/2021/04/15/how-does-postgres-handle-external-parameters/

https://www.enterprisedb.com/blog/regression-analysis-postgresql-tensorflow-part-2-data-pre-processing

https://postgresql.life/post/devrim_gunduz/