PG-Admin

PostgreSQL official repos cut off global mirror sync channels, open-source binaries supply disrupted, revealing the true colors of various database and cloud vendors.

PGDG cuts off FTP rsync sync channels, global mirror sites universally disconnected - this time they really strangled global users' supply chain.

**Query optimization** is one of the core responsibilities of DBAs. This article introduces how to use metrics provided by `pg_stat_statements` for macro-level PostgreSQL query optimization.

Backups are a DBA's lifeline — but what if your PostgreSQL database has already exploded and you have no backups? Maybe `pg_filedump` can help you!

What? Don't know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!

This article introduces the principles and best practices of logical replication in PostgreSQL 13.

Slow queries are the sworn enemy of OLTP databases. Here’s how to identify, analyze, and fix them using metrics (Pigsty dashboards), pg_stat_statements, and logs.

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

How to change column types online, such as upgrading from INT to BIGINT?

Understanding the golden monitoring metrics in PostgreSQL

Concepts and their naming are very important. Naming style reflects an engineer's understanding of system architecture. Poorly defined concepts lead to communication confusion, while carelessly set names create unexpected additional burden. Therefore, they need careful design.

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

Today encountered an interesting case where a customer reported database connection issues caused by extensions.

Replication is one of the core issues in system architecture.

There are various backup strategies. Physical backups can usually be divided into four types.

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.

PostgreSQL uses MVCC as its primary concurrency control technology. While it has many benefits, it also brings other effects, such as relation bloat.

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

PipelineDB is a PostgreSQL extension for streaming analytics. Here’s how to install it and build continuous views over live data.

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.

PgAdmin is a GUI program for managing PostgreSQL, written in Python, but it's quite dated and requires some additional configuration.

Recently there was a perplexing incident where a database had half its data volume and load migrated away, but ended up being overwhelmed due to increased load.

Some tips for interacting between PostgreSQL and Bash.

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

Backup is the foundation of a DBA's livelihood. With backups, there's no need to panic.

Pgbouncer is a lightweight database connection pool. This guide covers basic Pgbouncer configuration, management, and usage.

PgBackRest is a set of PostgreSQL backup tools written in Perl

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.

FIO is a convenient tool for testing disk I/O performance

It's recommended to configure PostgreSQL's log format as CSV for easy analysis, and it can be directly imported into PostgreSQL data tables.

Indexes are useful, but they're not free. Unused indexes are a waste. Use these methods to identify unused indexes.

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.

With `file_fdw`, you can easily view operating system information, fetch network data, and feed various data sources into your database for unified viewing and management.

PostGIS is PostgreSQL's killer extension, but compiling and installing it isn't easy.

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.