Episode 125 Scaling Suggestions | Slot Safety | SCRAM Channel Binding | Effective Cache Size

<p>In this episode of Scaling Postgres, we discuss suggestions for scaling postgres, replication slots safety, implementing scram password authentication with channel binding and setting effective_cache_size.</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://hakibenita.com/sql-tricks-application-dba">https://hakibenita.com/sql-tricks-application-dba</a></p> <p><a href= "https://stribny.name/blog/2020/07/scaling-relational-sql-databases"> https://stribny.name/blog/2020/07/scaling-relational-sql-databases</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/pg13-slot-size-limit/">https://www.2ndquadrant.com/en/blog/pg13-slot-size-limit/</a></p> <p><a href= "https://www.depesz.com/2020/07/27/waiting-for-postgresql-14-rename-wal_keep_segments-to-wal_keep_size/"> https://www.depesz.com/2020/07/27/waiting-for-postgresql-14-rename-wal_keep_segments-to-wal_keep_size/</a></p> <p><a href= "https://www.citusdata.com/blog/2020/07/28/securely-authenticate-with-scram-in-postgres-13/"> https://www.citusdata.com/blog/2020/07/28/securely-authenticate-with-scram-in-postgres-13/</a></p> <p><a href= "https://www.percona.com/blog/2020/07/28/migrating-to-postgresql-version-13-incompatibilities-you-should-be-aware-of/"> https://www.percona.com/blog/2020/07/28/migrating-to-postgresql-version-13-incompatibilities-you-should-be-aware-of/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/effective_cache_size-a-practical-example/"> https://www.cybertec-postgresql.com/en/effective_cache_size-a-practical-example/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/webinar-being-committed-a-review-of-transaction-control-statements-1-3-follow-up-2/"> https://www.2ndquadrant.com/en/blog/webinar-being-committed-a-review-of-transaction-control-statements-1-3-follow-up-2/</a></p> <p><a href= "https://www.sqlstyle.guide/">https://www.sqlstyle.guide/</a></p> <p><a href= "https://momjian.us/main/blogs/pgblog/2020.html#July_29_2020">https://mom