Extended Statistics in PG19: Virtual Columns, pg_restore_extended_stats(), pg_clear_extended_stats() and pg_dump
Introduction: Have you ever wondered why an Optimized PostgreSQL query suddenly becomes slow, and why the query planner chose a
Others, PG19 Hacktober
PG19 Hacktober: 31 Days of New Features: Watching VACUUM and ANALYZE: New Progress Columns, Logging and WAL Full-Page-Image Reporting
We’re just into the 5th day of PG19 Hacktober, and we continue to see how PostgreSQL 19 beta 4 improves
How PostgreSQL Temporary Files Affect Query Performance and How work_mem Optimization Improves It
Introduction: Have you ever faced a situation where a PostgreSQL query that usually finishes in a few seconds suddenly starts taking
Selective Row-Level Filtering in PostgreSQL Logical Replication
Imagine a scenario: You are a DBA at a large-scale e-commerce company. Your primary database hasgrown to 10 million rows
Selective Row-Level Filtering in PostgreSQL Logical Replication Read Post »