-
S3: Elite to Mediocre
2023-12-26 in Cloud Exit
Object storage (S3) has been a defining service of cloud computing, once hailed as a paragon of cost reduction in the cloud era. Unfortunately, with the evolution of hardware and the emergence of resources cloud (Cloudflare R2) and open-source …
-
Database in K8S: Pros & Cons
2023-12-06 in Database
Whether databases should be housed in Kubernetes/Docker remains highly controversial. While Kubernetes (k8s) excels in managing stateless applications, it has fundamental drawbacks with stateful services, especially databases like PostgreSQL and …
-
PostgreSQL Convention 2024
2023-11-27 in Postgres
Background 0x01 Naming Convention 0x01 Design Convention 0x01 Query Convention 0x01 Admin Convention Roughly translated from PostgreSQL Convention 2024 with Google. 0x00 Background No Rules, No Lines The functions of PostgreSQL are very powerful, …
-
Reclaim Hardware Bonus from the Cloud
2023-11-16 in Cloud Exit
Hardware is interesting again, with the AI wave fueling a GPU frenzy. However, the intrigue isn’t limited to GPUs —— developments in CPUs and SSDs remain largely unnoticed by the majority of devs. A whole generation of developers is obscured by cloud …
-
Query Optimization: The Macro Approach with pg_stat_statements
2023-10-26 in PG Admin
In production databases, slow queries not only impact end-user experience but also waste system resources, increase resource saturation, cause deadlocks and transaction conflicts, add pressure to database connections, and lead to replication lag. …
-
v2.5: Debian / Ubuntu / PG16
2023-10-24 in Releases
v2.5.0 curl https://get.pigsty.io/latest | bash Highlights Ubuntu / Debian Support: bullseye, bookworm, jammy, focal Dedicate yum/apt repo on repo.pigsty.cc and mirror on packagecloud.io Anolis OS Support (EL 8.8 Compatible) PG Major Candidate: Use …
-
FerretDB: When PG Masquerades as MongoDB
2023-10-08 in Postgres
MongoDB was once a revolutionary technology that liberated developers from the “schema shackles” of relational databases, enabling rapid application development. However, as time passed, MongoDB gradually drifted away from its open-source …
-
Rescue Data with pg_filedump?
2023-09-27 in PG Admin
Backups are a DBA’s lifeline — but what if your PostgreSQL database has crashed without any backups? Maybe pg_filedump can help! Recently, I encountered a rather challenging case. Here’s the situation: A user’s PostgreSQL database …
-
v2.4: Monitoring Cloud RDS
2023-09-14 in Releases
v2.4.0 Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)". Highlights PostgreSQL 16 support The first LTS version with business support and consulting service Monitoring existing PostgreSQL, RDS for PostgreSQL / PolarDB …
-
v2.3: Ecosystem Applications
2023-08-20 in Releases
v2.3.0 PGSQL/REDIS Update, NODE VIP, Mongo/FerretDB, MYSQL Stub Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)" Highlight INFRA: NODE/PGSQL VIP monitoring support NODE: Allow bind node_vip to node cluster with …