PgBouncer, PgCat, Supavisor Fight!!! | Scaling Postgres 303

In this episode of Scaling Postgres, we discuss new Postgres releases, performance comparisons between PgBouncer, PgCat and Supavisor, a new extension pg_analytics, and new planner capabilities in PG16.

Content Discussed

• Postgres Performance Demystified Webinar
• PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!
• Benchmarking PostgreSQL connection poolers: PgBouncer, PgCat and Supavisor
• pg_analytics: Transforming Postgres into a Fast OLAP Database
• What’s new in the Postgres 16 query planner / optimizer
• Faster query plans with Postgres 16: Incremental Sorts, Anti-JOINs and more
• Recommended resources to improve your knowledge of Databases and PostgreSQL
• Waiting for PostgreSQL 17 – Support identity columns in partitioned tables
• Waiting for PostgreSQL 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERROR
• Connecting to Postgres With psql and .pg_service.conf
• Exploiting SQL/JSON Enhancements for Modern Workloads in PostgreSQL 16
• Postgres Not Starting: The Case of the Missing Output
• Postgres 16 contribution analysis 2023
• Which Companies are Supporting PostgreSQL Development?
• Matryoshka embeddings: faster OpenAI vector search using Adaptive Retrieval
• Hosting a set of Postgres Demo databases
• Enhance PostgreSQL TLS Security with OCSP Stapling
• PostgreSQL Column Alignment and Padding – How To Improve Performance With Smarter Table Design
• PostGIS Clustering with K-Means
• (Plausible) Random Geography Generation with PostGIS: Fluviation
• pgagroal-cli gains JSON output
• Review: PostgreSQL 16 Administration Cookbook
• Deciphering PostgreSQL Encryption: A Beginner’s Guide
• Enhancing PostgreSQL Performance by Scaling Horizontally using PL/Proxy
• The four quadrants of an Oracle migration
• pgvector: 30x Faster Index Build for your Vector Embeddings
• Learning about "transqlate" at PG Session 16
• PG Day Chicago Schedule is announced!
• Back from FOSDEM 2024

YouTube Video

Podcast Audio