Episode 226 SQL Functions, Explain Analyze Buffers, Debug Autovacuum, RLS Multi-Tenancy

<p>In this episode of Scaling Postgres, we discuss PG14's new SQL function syntax, including buffers when doing explain analyze, how to debug autovacuum and using row-level security to handle multi-tenancy.</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://www.cybertec-postgresql.com/en/better-sql-functions-in-postgresql-v14/"> https://www.cybertec-postgresql.com/en/better-sql-functions-in-postgresql-v14/</a></li> <li><a href= "https://jkatz05.com/post/postgres/postgres-begin-atomic/">https://jkatz05.com/post/postgres/postgres-begin-atomic/</a></li> <li><a href= "https://www.pgmustard.com/blog/using-postgres-buffers-for-query-optimization"> https://www.pgmustard.com/blog/using-postgres-buffers-for-query-optimization</a></li> <li><a href= "https://www.citusdata.com/blog/2022/07/28/debugging-postgres-autovacuum-problems-13-tips/"> https://www.citusdata.com/blog/2022/07/28/debugging-postgres-autovacuum-problems-13-tips/</a></li> <li><a href= "https://www.thenile.dev/blog/multi-tenant-rls">https://www.thenile.dev/blog/multi-tenant-rls</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-row-level-security-bypassrls-security-invoker-views-leakproof-functions"> https://pganalyze.com/blog/5mins-postgres-row-level-security-bypassrls-security-invoker-views-leakproof-functions</a></li> <li><a href= "https://www.timescale.com/blog/state-of-postgresql-2022-13-tools-that-arent-psql/"> https://www.timescale.com/blog/state-of-postgresql-2022-13-tools-that-arent-psql/</a></li> <li><a href= "https://www.youtube.com/c/percona/videos">https://www.youtube.com/c/percona/videos</a></li> <li><a href= "https://www.crunchydata.com/blog/native-partitioning-with-postgres"> https://www.crunchydata.com/blog/native-partitioning-with-postgres</a></li> <li><a href= "https://www.endpointdev.com/blog/2022/07/running-postgresql-on-docker/"> https://www.endpointdev.com/blog/2022/07/running-postgresql-on-docker/</a></li> <li><a href= "https:/