PostgreSQL Performance Tuning - From 500ms to 20ms Queries
Practical PostgreSQL performance tuning techniques that reduced query times from 500ms to 20ms, including indexing strategies, query optimization, and configuration tuning.
🏷️ postgresql
7 posts
PostgreSQL JSON Performance - Optimizing JSONB Queries
Optimizing PostgreSQL JSONB queries from 2 seconds to 50ms using indexes, query planning, and schema design.
PostgreSQL 13: Performance Improvements That Matter
Upgraded to PostgreSQL 13 - B-tree deduplication, parallel vacuum, incremental sort. Query performance improved by 40%, vacuum 2x faster
Running Stateful Applications on Kubernetes: StatefulSets Deep Dive
My experience running PostgreSQL and Redis on Kubernetes using StatefulSets, including storage, networking, and backup strategies
PostgreSQL Backup and Recovery: Lessons from a 3AM Data Loss Incident
Implementing robust PostgreSQL backup strategies - pg_dump, pg_basebackup, PITR, and the disaster recovery plan that saved our business
PostgreSQL Query Optimization: From 5s to 50ms
How I optimized slow database queries using indexes, query analysis, and caching strategies
PostgreSQL Index Optimization: From 12s to 80ms
Optimizing slow queries with proper indexing strategies - B-tree, partial indexes, and covering indexes in production