Pigsty Blog Articles
PostgreSQL's Impressive Scalability
January 13, 2024 in PostgreSQL
This article describes how Cloudflare scaled to support 55 million requests per second using 15 PostgreSQL clusters, and PostgreSQL's scalability performance.
This article describes how Cloudflare scaled to support 55 million requests per second using 15 PostgreSQL clusters, and PostgreSQL's scalability performance.
Cloud-Exit High Availability Secret: Rejecting Complexity Masturbation
January 10, 2024 in Cloud
Programmers are drawn to complexity like moths to flame. The more complex the system architecture diagram, the greater the intellectual masturbation high. Steadfast resistance to this behavior is a key reason for DHH's success in cloud-free availability.
Programmers are drawn to complexity like moths to flame. The more complex the system architecture diagram, the greater the intellectual masturbation high. Steadfast resistance to this behavior is a key reason for DHH's success in cloud-free availability.
PostgreSQL Wins 2024 Database of the Year Award! (Fifth Time)
January 05, 2024 in PostgreSQL
DB-Engines officially announced today that PostgreSQL has once again been crowned "Database of the Year." This is the fifth time PG has received this honor in the past seven years. If not for Snowflake stealing the spotlight for two years, the database world would have almost become a PostgreSQL solo show.
DB-Engines officially announced today that PostgreSQL has once again been crowned "Database of the Year." This is the fifth time PG has received this honor in the past seven years. If not for Snowflake stealing the spotlight for two years, the database world would have almost become a PostgreSQL solo show.
PostgreSQL Outlook for 2024
January 05, 2024 in PostgreSQL
PostgreSQL core team member Jonathan Katzs outlook for PostgreSQL in 2024, reviewing the progress made over the past few years.
PostgreSQL core team member Jonathan Katzs outlook for PostgreSQL in 2024, reviewing the progress made over the past few years.
How Can MySQL's Correctness Be This Garbage?
December 28, 2023 in Database
MySQL's transaction ACID has flaws and doesn't match documentation promises. This may lead to serious correctness issues - use with caution.
MySQL's transaction ACID has flaws and doesn't match documentation promises. This may lead to serious correctness issues - use with caution.
S3: Elite to Mediocre
December 26, 2023 in Cloud
S3 is no longer "cheap" with the evolution of hardware, and other challengers such as cloudflare R2.
S3 is no longer "cheap" with the evolution of hardware, and other challengers such as cloudflare R2.
Cloud Exit FAQ: DHH Saves Millions
December 21, 2023 in Cloud
DHHs cloud exit journey has reached a new stage, saving nearly a million dollars so far with potential savings of nearly ten million over the next five years.
DHHs cloud exit journey has reached a new stage, saving nearly a million dollars so far with potential savings of nearly ten million over the next five years.
Database in K8S: Pros & Cons
December 06, 2023 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 …
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 …
Pigsty v2.5: Ubuntu & PG16
December 01, 2023 in Pigsty
Pigsty v2.5 adds Ubuntu/Debian support (bullseye, bookworm, jammy, focal), new extensions including pointcloud and imgsmlr, and redesigned monitoring dashboards.
Pigsty v2.5 adds Ubuntu/Debian support (bullseye, bookworm, jammy, focal), new extensions including pointcloud and imgsmlr, and redesigned monitoring dashboards.
From Cost-Reduction Jokes to Real Cost Reduction and Efficiency
November 29, 2023 in Cloud
Alibaba-Cloud and Didi had major outages one after another. This article discusses how to move from cost-reduction jokes to real cost reduction and efficiency — what costs should we really reduce, what efficiency should we improve?
Alibaba-Cloud and Didi had major outages one after another. This article discusses how to move from cost-reduction jokes to real cost reduction and efficiency — what costs should we really reduce, what efficiency should we improve?