Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://hakibenita.com/sql-tricks-application-dba https://stribny.name/blog/2020/07/scaling-relational-sql-databases https://www.2ndquadrant.com/en/blog/pg13-slot-size-limit/ https://www.depesz.com/2020/07/27/waiting-for-postgresql-14-rename-wal_keep_segments-to-wal_keep_size/ https://www.citusdata.com/blog/2020/07/28/securely-authenticate-with-scram-in-postgres-13/ https://www.percona.com/blog/2020/07/28/migrating-to-postgresql-version-13-incompatibilities-you-should-be-aware-of/ https://www.cybertec-postgresql.com/en/effective_cache_size-a-practical-example/ https://www.2ndquadrant.com/en/blog/webinar-being-committed-a-review-of-transaction-control-statements-1-3-follow-up-2/ https://www.sqlstyle.gu