Scaling Postgres

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-postgres