Pigsty Blog Articles
Pigsty v2.6: PostgreSQL Crashes the OLAP Party
February 28, 2024 in Pigsty
Pigsty v2.6 makes PostgreSQL 16.2 the default, introduces ParadeDB and DuckDB support, and brings epic-level OLAP improvements.
Pigsty v2.6 makes PostgreSQL 16.2 the default, introduces ParadeDB and DuckDB support, and brings epic-level OLAP improvements.
Technical Minimalism: Just Use PostgreSQL for Everything
February 19, 2024 in PostgreSQL
Whether **production databases** should be containerized remains a controversial topic. From a DBA's perspective, I believe that **currently**, putting production databases in Docker is still a bad idea.
Whether **production databases** should be containerized remains a controversial topic. From a DBA's perspective, I believe that **currently**, putting production databases in Docker is still a bad idea.
New PostgreSQL Ecosystem Player: ParadeDB
February 18, 2024 in PostgreSQL
ParadeDB aims to be an Elasticsearch alternative: "Modern Elasticsearch Alternative built on Postgres" — PostgreSQL for search and analytics.
ParadeDB aims to be an Elasticsearch alternative: "Modern Elasticsearch Alternative built on Postgres" — PostgreSQL for search and analytics.
Will DBAs Be Eliminated by Cloud?
February 02, 2024 in Cloud
Two days ago, the ninth episode of Open-Source Talks had the theme "Will DBAs Be Eliminated by Cloud?" As the host, I restrained myself from jumping into the debate throughout, so I'm writing this article to discuss this question: Will DBAs be eliminated by cloud?
Two days ago, the ninth episode of Open-Source Talks had the theme "Will DBAs Be Eliminated by Cloud?" As the host, I restrained myself from jumping into the debate throughout, so I'm writing this article to discuss this question: Will DBAs be eliminated by cloud?
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.