-
Slow Query Diagnosis
2021-02-23 in PG Admin
You can’t optimize what you can’t measure Slow queries are the arch-enemy of online business databases. Knowing how to diagnose and locate slow queries is an essential skill for DBAs. This article introduces a general methodology for …
-
v0.6.0 Release Note
2021-02-19 in Releases
v0.6.0 Bug Fix pg_hba reset on patroni restart (patroni 2.0) #5 Merge Fix name of dashboard #1, Fix PG Overview Dashboard typo Fix default primary instance to pg-test-1 of cluster pg-test in sandbox environment Fix obsolete comments Enhancement …
-
v0.5.0 Release Note
2020-12-20 in Releases
v0.5.0 Pigsty now have an Official Site 🎉 ! New Features Add Database Provision Template Add Init Template Add Business Init Template Refactor HBA Rules variables Fix dashboards bugs. Move pg-cluster-replication to default dashboards Use ZJU …
-
v0.4.0 Release Note
2020-12-14 in Releases
v0.4.0 The second public beta (v0.4.0) of pigsty is available now ! 🎉 Monitoring System Skim version of monitoring system consist of 10 essential dashboards: PG Overview PG Cluster PG Service PG Instance PG Database PG Query PG Table PG Table …
-
v0.3.0 Release Note
2020-10-24 in Releases
v0.3.0 The first public beta (v0.3.0) of pigsty is available now ! 🎉 Monitoring System Skim version of monitoring system consist of 8 essential dashboards: PG Overview PG Cluster PG Service PG Instance PG Database PG Table Overview PG Table Catalog …
-
Is running postgres in docker a good idea?
2019-01-13 in Database
For stateless app services, containers are an almost perfect devops solution. However, for stateful services like databases, it’s not so straightforward. Whether production databases should be containerized remains controversial. From a …
-
What Makes PostgreSQL So Awesome?
2018-06-10 in Postgres
PostgreSQL’s slogan is “The World’s Most Advanced Open Source Relational Database”, but I find this tagline lacks punch. It also feels like a direct jab at MySQL’s “The World’s Most Popular Open Source …