Scaling Postgres Episode 226 SQL Functions, Explain Analyze Buffers, Debug Autovacuum, RLS Multi-Tenancy
Get New Episodes Weekly!
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.
Content Discussed
- Better SQL functions in PostgreSQL v14
- BEGIN ATOMIC: a better way to create functions in PostgreSQL 14
- Using BUFFERS for query optimization
- Debugging Postgres autovacuum problems: 13 tips
- Shipping multi-tenant SaaS using Postgres Row-Level Security
- 5mins of Postgres E28: Row Level Security in Postgres, security invoker views and why LEAKPROOF functions matter
- State of PostgreSQL 2022—13 Tools That Aren't psql
- Percona YouTube Channel
- Partitioning with Native Postgres and pg_partman
- Running PostgreSQL on Docker
- Elizabeth Garrett Christensen
- Rubber Duck Dev Show Episode 52 | The Agile Manifesto's 12 Principles
YouTube Video
