Scaling Postgres Episode 209 Tidy Vacuum, Dropping Roles, Merge Command, PgBouncer Tutorial
Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss how to optimize vacuum, how to drop roles, the new merge command in PG15 and a pgbouncer tutorial.
Content Discussed
- PG Phriday: Tidying Up With VACUUM
- How to DROP ROLE or DROP USER in PostgreSQL
- Waiting for PostgreSQL 15 – Add support for MERGE SQL command
- SQL Merge
- [YouTube] PgBouncer Tutorial
- Waiting for PostgreSQL 15 – SQL/JSON constructors
- Waiting for PostgreSQL 15 – IS JSON predicate
- Waiting for PostgreSQL 15 – SQL/JSON query functions
- parallel commit in postgres fdw
- How Postgres Chooses Which Index To Use For A Query
- Queries in PostgreSQL: 3. Sequential scan
- Ultimate Guide to Citus Con: An Event for Postgres
- Identify PostgreSQL Performance Bottlenecks With pg_stat_statements
- Installing Crunchy Postgres Operator v5 on EKS
- Claire Giordano
- Rubber Duck Dev Show Episode 36 | Redundant Infrastructure on the Cheap
YouTube Video
