Postgres Releases = Reindexing | Scaling Postgres 290

In this episode of Scaling Postgres, we discuss my Postgres Performance Starter Kit, new releases of Postgres, removing JIT, and a lightweight message queue.

Content Discussed

• PostgreSQL Performance Start Kit
• PostgreSQL 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 Released!
• Django: Maybe disable PostgreSQL’s JIT to speed up many-joined queries
• PGMQ: Lightweight Message Queue on Postgres with No Background Worker
• Tuple shuffling: Postgres CTEs for Moving and Deleting Table Data
• Ruby on Rails Neighbor Gem for AI Embeddings
• Data model trade-offs
• Introducing Dynamic PostgreSQL: How We Are Evolving the Database to Help You Sleep at Night
• Using multiple triggers on the same table in PostgreSQL
• SQL Scoping is Surprisingly Subtle and Semantic
• Writing a storage engine for Postgres: an in-memory Table Access Method
• PostgreSQL Encryption: The Available Options
• Navigating a Usage-Based Model for PostgreSQL: Tips to Reduce Your Database Size
• What is pgvector and How Can It Help You?
• PostgreSQL 17: part 2 or CommitFest 2023-09
• Tips for Row Level Security (RLS) in Postgres and Supabase
• Getting connected to PostgreSQL for the first time
• Performance tuning in PostgreSQL using shared_buffers
• PostgreSQL 17: New catalog view pg_stat_checkpointer
• The pg_stat_checkpointer view in Postgres 17
• Managing PostgreSQL Like a Pro: A Kubernetes-based pgAdmin Tutorial
• How To Scale a Single-Host PostgreSQL Database With Citus
• Efficient Time-Series Data Handling: Exploring TimescaleDB in PostgreSQL
• What is the maximum number of columns for a table in PostgreSQL?
• How To Install Postgres On WSL2 Along With pgAdmin
• Scram Is Here to Stay
• PostgreSQL Checkpoints, Buffers, and WAL Usage with Percona Monitoring and Management
• Boosting Postgres Performance With Prepared Statements and PgBouncer's Transaction Mode
• DBVISIT StandbyMP for PostgreSQL – 3 – Switchovers

YouTube Video

Podcast Audio