Tag Archives: PostgreSQL

A customer who had migrated from Oracle to PostgreSQL several years ago recently reported a serious performance regression. A critical table—now holding over 700 million rows—had become extremely slow when filtering by date. As an DBA, I approached this from an Oracle perspective: partition pruning, local indexes. PostgreSQL partitioning is broadly similar to Oracle’s, butContinue reading “Partitioning in PostgreSQL vs Oracle”