Scaling Suggestions, Slot Safety, SCRAM Channel Binding, Effective Cache Size | Scaling Postgres 125
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.guide/
https://momjian.us/main/blogs/pgblog/2020.html#July_29_2020
https://info.crunchydata.com/blog/announcing-pgbackrest-for-azure-fast-reliable-postgres-backups
https://b-peng.blogspot.com/2020/07/connection-pooling-in-pgpool.html
https://amitdkhan-pg.blogspot.com/2020/07/backtraces-in-postgresql.html
https://postgresql.life/post/gilberto_castillo/
Create your
podcast in
minutes
It is Free