-
pg_exporter v1.0.0 Released – Next-Level PostgreSQL Observability
2025-05-08 in Postgres
We’re delighted to announce pg_exporter v1.0.0, an advanced open-source Prometheus exporter that takes PostgreSQL observability to the next level. Built for DBAs and developers who need deep insight, pg_exporter exposes 600 + metrics—roughly 3 K – 20 …
-
OrioleDB is Here! 4x Performance, Zero Bloat, Decoupled Storage
2025-04-06 in Postgres
OrioleDB - while the name might make you think of cookies, it’s actually named after the songbird. But whether you call it Cookie DB or Bird DB doesn’t matter - what matters is that this PG storage engine extension + kernel fork is …
-
OpenHalo: PostgreSQL Now Speaks MySQL Wire Protocol!
2025-04-03 in Postgres
PostgreSQL speaking MySQL? Yes, you read that right. OpenHalo, freshly open-sourced on April Fools’ Day, brings this capability to life - allowing users to read, write, and manage the same database using both MySQL and PostgreSQL clients. Built …
-
v3.4: MySQL Wire-Compatibility and Improvements
2025-03-31 in Releases
After a month of intensive development, Pigsty v3.4 is officially released! This release brings support for a new PostgreSQL kernel and significant architectural optimizations, addressing several key concerns from customers and users: Support for …
-
PGFS: Using PostgreSQL as a File System
2025-03-21 in Postgres
Recently, I received an interesting request from the Odoo community. They were grappling with a fascinating challenge: “If databases can do PITR (Point-in-Time Recovery), is there a way to roll back the file system as well?” The Birth of …
-
Database Planet Collision: When PG Falls for DuckDB
2025-03-12 in Database
When I published “PostgreSQL Is Eating the Database World” last year, I tossed out this wild idea: Could Postgres really unify OLTP and OLAP? I had no clue we’d see fireworks so quickly. The PG community’s now in an all-out frenzy to stitch DuckDB …
-
v3.3：Extension 404，Odoo, Dify, Supabase, Nginx Enhancement
2025-02-25 in Releases
After two months of careful polishing, Pigsty v3.3 is officially released! As an open-source, “battery-included” PostgreSQL distribution, Pigsty aims to optimize the PostgreSQL ecosystem and provide smooth self-hosting experience just …
-
PostgreSQL Frontier
2025-01-24 in Postgres
Dear readers, I’m off on vacation starting today—likely no new posts for about two weeks. Let me wish everyone a Happy New Year in advance. Of course, before heading out, I wanted to share some recent interesting developments in the Postgres …
-
v3.2: The pig CLI, ARM64 Repo, Self-hosting Supabase
2024-12-29 in Releases
The New Year is just around the corner, and Pigsty is celebrating the last release of 2024 with v3.2. This release introduces a new command-line tool, pig, and enhanced ARM extension support. Together, these features deliver a smooth PostgreSQL …
-
Pig, The PostgreSQL Extension Wizard
2024-12-29 in Postgres
Ever wished installing or upgrading PostgreSQL extensions didn’t feel like digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches? The painful truth is that Postgres’s richness of extension often comes at …