
Episode 161 Scaling Lessons | Synchronous Commit | Connection Management | BLOB Cleanup
Bikking
Description
<p>In this episode of Scaling Postgres, we discuss 5 years of scaling lessons, working with synchronous commit, managing connections and cleaning up BLOBs.</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://onesignal.com/blog/lessons-learned-from-5-years-of-scaling-postgresql/"> https://onesignal.com/blog/lessons-learned-from-5-years-of-scaling-postgresql/</a><br /> <br /> <a href= "https://momjian.us/main/blogs/pgblog/2021.html#April_14_2021">https://momjian.us/main/blogs/pgblog/2021.html#April_14_2021</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/your-guide-to-connection-management-in-postgres"> https://blog.crunchydata.com/blog/your-guide-to-connection-management-in-postgres</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/cleaning-up-large-number-blobs/"> https://www.cybertec-postgresql.com/en/cleaning-up-large-number-blobs/</a><br /> <br /> <a href= "https://www.keithf4.com/managing-transaction-id-exhaustion-wraparound-in-postgresql/"> https://www.keithf4.com/managing-transaction-id-exhaustion-wraparound-in-postgresql/</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/postgres-is-out-of-disk-and-how-to-recover-the-dos-and-donts"> https://blog.crunchydata.com/blog/postgres-is-out-of-disk-and-how-to-recover-the-dos-and-donts</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/finally-a-system-level-read-all-data-role-for-postgresql/"> https://www.cybertec-postgresql.com/en/finally-a-system-level-read-all-data-role-for-postgresql/</a><br /> <br /> <a href= "https://www.citusdata.com/blog/2021/04/10/talk-at-cmu-how-citus-distributes-postgresql-via-extension-apis/"> https://www.citusdata.com/blog/2021/04/10/talk-at-cmu-how-citus-distributes-postgresql-via-extension-apis/</a><br /> <br /> <a href= "https://www.enterprisedb.com/blog/benchmarking-postgresql-setting-raid-array-scratch"> https://www.enterprisedb.com/blog/benchmarking-postgresql-setting-raid-array-sc