Mission-critical databases have a unique challenge: the essential ability to perform online maintenance without disrupting applications. PostgreSQL and Oracle take different paths to achieve this, but both offer powerful tools that can reshape objects, reclaim space, and optimize performance with minimal downtime. In this session, we’ll compare PostgreSQL’s pg_repack, (a widely adopted extension for online table and index maintenance) against Oracle’s robust DBMS_REDEFINITION package.

Using demos and real-world examples, we’ll walk through how each technology handles common challenges such as bloat, fragmentation, schema changes, and keeping systems online during maintenance operations. Attendees will see where pg_repack shines, where it differs from Oracle’s online redefinition capabilities, and how to choose the right approach depending on scale, architecture, and operational requirements.

Whether you’re a Postgres fan wanting to add it to your maintenance toolkit or an Oracle DBA exploring what open-source databases can do, this comparison will highlight strengths, limitations, and practical guidance for modern, low-downtime data operations.