Search

Home > Scaling Postgres > Episode 125 Scaling Suggestions | Slot Safety | SCRAM Channel Binding | Effective Cache Size
Podcast: Scaling Postgres
Episode:

Episode 125 Scaling Suggestions | Slot Safety | SCRAM Channel Binding | Effective Cache Size
Category: Technology
Duration: 00:15:01
Publish Date: 2020-08-03 00:16:29
Description:

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/

 
Total Play: 0