Scaling Postgres

In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS Day and how to use multiple pgbouncers. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://pganalyze.com/blog/5mins-postgres-performance-in-lists-vs-any-operator-bind-parameters https://sqlfordevs.com/ghost-conditions-for-unindexed-columns https://www.crunchydata.com/blog/percentage-calculations-using-postgres-window-functions https://www.postgresonline.com/journal/index.php?/archives/406-VARIADIC-Unnest.html https://supabase.com/blog/sql-or-nosql-both-with-postgresql https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public/ https://www.highgo.ca/2022/11/25/global-index-benchmark-with-pgbench/ https://fluca1978.github.io/2022/11/24/PostgreSQLDataSyncRetry.html https://postgres.fm/episodes/materialized-views https://postgresql.life/post/tobias_bussmann/