Episode 243 IN vs ANY, Ghost Conditions, Percentage Calculations, Variadic Unnest

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://pganalyze.com/blog/5mins-postgres-performance-in-lists-vs-any-operator-bind-parameters"> https://pganalyze.com/blog/5mins-postgres-performance-in-lists-vs-any-operator-bind-parameters</a></li> <li><a href= "https://sqlfordevs.com/ghost-conditions-for-unindexed-columns">https://sqlfordevs.com/ghost-conditions-for-unindexed-columns</a></li> <li><a href= "https://www.crunchydata.com/blog/percentage-calculations-using-postgres-window-functions"> https://www.crunchydata.com/blog/percentage-calculations-using-postgres-window-functions</a></li> <li><a href= "https://www.postgresonline.com/journal/index.php?/archives/406-VARIADIC-Unnest.html"> https://www.postgresonline.com/journal/index.php?/archives/406-VARIADIC-Unnest.html</a></li> <li><a href= "https://supabase.com/blog/sql-or-nosql-both-with-postgresql">https://supabase.com/blog/sql-or-nosql-both-with-postgresql</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public/"> https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public/</a></li> <li><a href= "https://www.highgo.ca/2022/11/25/global-index-benchmark-with-pgbench/"> https://www.highgo.ca/2022/11/25/global-index-benchmark-with-pgbench/</a></li> <li><a href= "https://fluca1978.github.io/2022/11/24/PostgreSQLDataSyncRetry.html"> https://fluca1978.github.io/2022/11/24/PostgreSQLDataSyncRetry.html</a></li> <li><a href= "https://postgres.fm/episodes/materialized-views">https://postgres.fm/episodes/materialized-views</a></li> <li><a href= "https://postgresql.life/post/tobias_bussmann/">https://postgresql.life/post/tobias_bussmann/</a></li> </ul> <p> </p>