PG Management

Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start.

Managing databases is similar to managing people - both need KPIs (Key Performance Indicators). So what are database KPIs? This article introduces a way to measure PostgreSQL load: using a single horizontally comparable metric that is basically independent of workload type and machine type, called PG Load.

How to modify PostgreSQL column types online? A general approach

Replication is one of the core issues in system architecture.

Sometimes, interactions between components manifest in subtle ways. For example, using pg_dump to export data from a connection pool can cause connection pool contamination issues.

Using binary editing to repair PostgreSQL data pages, and how to make a primary key query return two records.

TimescaleDB is a PostgreSQL extension plugin that provides time-series database functionality.

XID WrapAround is perhaps a unique type of failure specific to PostgreSQL

If you use Integer sequences on tables, you should consider potential overflow scenarios.

Tables in PostgreSQL correspond to many physical files. This article explains how to calculate the actual size of a table in PostgreSQL.

Cars need oil changes, databases need maintenance. For PG, three important maintenance tasks: backup, repack, vacuum

Data migration typically involves stopping services for updates. Zero-downtime data migration is a relatively advanced operation.

Although PostgreSQL provides pgbench, sometimes you need sysbench to outperform MySQL.

Quick configuration for passwordless login to all machines

Wireshark is a very useful tool, especially suitable for analyzing network protocols. Here’s a simple introduction to using Wireshark for packet capture and PostgreSQL protocol analysis.

top, free, vmstat, iostat: Quick reference for four commonly used CLI tools

Recently had business requirements to access MongoDB through PostgreSQL FDW, but compiling MongoDB FDW is really a nightmare.