Learn how to use pgcopydb’s –follow option and logical replication slots to achieve near-zero downtime live migrations of PostgreSQL databases.
Tag: PostgreSQL
Technical Architecture and Parallelization in pgcopydb
A deep dive into pgcopydb’s multi-process architecture, table chunking features, and parallel index rebuilding capabilities for faster migrations.
pgcopydb: Redefining PostgreSQL Database Migration
Discover pgcopydb, a high-performance open-source tool by Dimitri Fontaine that revolutionizes PostgreSQL database migration by overcoming the limits of pg_dump.
Size and fill rate of PostgreSQL tables
Introduction In PostgreSQL, it is essential to understand how disk space is allocated to tables. This knowledge is crucial for efficient resource management, capacity planning, and preventing performance degradation. Indeed, unlike some database systems that store large tables in a single file, PostgreSQL uses a segmentation strategy. Understanding Tablespaces Before exploring the functions used to …