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.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

• https://www.cybertec-postgresql.com/en/better-sql-functions-in-postgresql-v14/
• https://jkatz05.com/post/postgres/postgres-begin-atomic/
• https://www.pgmustard.com/blog/using-postgres-buffers-for-query-optimization
• https://www.citusdata.com/blog/2022/07/28/debugging-postgres-autovacuum-problems-13-tips/
• https://www.thenile.dev/blog/multi-tenant-rls
• https://pganalyze.com/blog/5mins-postgres-row-level-security-bypassrls-security-invoker-views-leakproof-functions
• https://www.timescale.com/blog/state-of-postgresql-2022-13-tools-that-arent-psql/
• https://www.youtube.com/c/percona/videos
• https://www.crunchydata.com/blog/native-partitioning-with-postgres
• https://www.endpointdev.com/blog/2022/07/running-postgresql-on-docker/
• https://postgresql.life/post/elizabeth_garrett_christensen/
• https://www.rubberduckdevshow.com/episodes/52-agile-manifesto-12-principles/