PgBouncer, PgCat, Supavisor Fight!!! | Scaling Postgres 303
Join Over 1,000 Engineers & Get New Episodes Weekly!
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
