Tag Archive

#PostgreSQL

Articles tagged with #PostgreSQL

Zero-Downtime Database Migrations in Laravel at Scale: The Expand and Contract Pattern

#PostgreSQL

Sep 04, 2026

Zero-Downtime Database Migrations in Laravel at Scale: The Expand and Contract Pattern

A masterclass on executing database schema changes on multi-million row tables in Laravel without locking tables, dropping queries, or causing application downtime.

#PostgreSQL

Aug 27, 2026

Optimizing PostgreSQL for High-Concurrency Applications: Connection Pooling with PgBouncer, Index Strategies, and Vacuum Tuning

A production guide to scaling PostgreSQL for high-throughput workloads: eliminating connection process bloat with PgBouncer, sizing shared_buffers and work_mem, partial & BRIN indexing, and tuning autovacuum to prevent table bloat.