Learn how to use pgcopydb’s –follow option and logical replication slots to achieve near-zero downtime live migrations of PostgreSQL databases.
Tag: Administration
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.
Mastering the MySQL Client on Linux: Boost Your Command-Line Performance!
The MySQL command-line client on Linux is a powerful tool for interacting with your databases directly from the terminal. Whether you are a database administrator or a developer, mastering this tool can significantly improve your management and development workflows. 🚀 🛠️ Installing the MySQL Client on Linux: A Quick Guide Before getting started, here are […]
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 […]