Pigsty Blog Articles
Implementing Advanced Fuzzy Search
March 05, 2021 in PostgreSQL
How to implement relatively complex fuzzy search logic in PostgreSQL?
How to implement relatively complex fuzzy search logic in PostgreSQL?
PostgreSQL Logical Replication Deep Dive
March 03, 2021 in PostgreSQL
This article introduces the principles and best practices of logical replication in PostgreSQL 13.
This article introduces the principles and best practices of logical replication in PostgreSQL 13.
PG Replica Identity Explained
March 03, 2021 in PostgreSQL
Replica identity is important - it determines the success or failure of logical replication
Replica identity is important - it determines the success or failure of logical replication
Pigsty v0.4: PG13 and Better Docs
March 01, 2021 in Pigsty
Pigsty v0.4 ships PG13 support, a Grafana 7.3 refresh, and a cleaned-up docs site for the second public beta.
Pigsty v0.4 ships PG13 support, a Grafana 7.3 refresh, and a cleaned-up docs site for the second public beta.
A Methodology for Diagnosing PostgreSQL Slow Queries
February 23, 2021 in PostgreSQL
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.
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.
Incident-Report: Patroni Failure Due to Time Travel
February 22, 2021 in PostgreSQL
Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start.
Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start.
Online Primary Key Column Type Change
January 15, 2021 in PostgreSQL
How to change column types online, such as upgrading from INT to BIGINT?
How to change column types online, such as upgrading from INT to BIGINT?
Pigsty v0.3: First Public Beta
December 14, 2020 in Pigsty
Pigsty v0.3.0, the first public beta, lands with eight battle-tested dashboards and an offline bundle.
Pigsty v0.3.0, the first public beta, lands with eight battle-tested dashboards and an offline bundle.
Golden Monitoring Metrics: Errors, Latency, Throughput, Saturation
November 06, 2020 in PostgreSQL
Understanding the golden monitoring metrics in PostgreSQL
Understanding the golden monitoring metrics in PostgreSQL
Database Cluster Management Concepts and Entity Naming Conventions
June 03, 2020 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.
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.