Pigsty Blog Articles
Stop Arguing, The AI Era Database Has Been Settled
June 03, 2025 in Database
The database for the AI era has been settled. Capital markets are making intensive moves on PostgreSQL targets, with PG having become the default database for the AI era.
The database for the AI era has been settled. Capital markets are making intensive moves on PostgreSQL targets, with PG having become the default database for the AI era.
Open Data Standards: Postgres, OTel, and Iceberg
May 27, 2025 in Database
Three emerging standards in the data world: Postgres, OpenTelemetry, and Iceberg. Postgres is already the de facto standard.
Three emerging standards in the data world: Postgres, OpenTelemetry, and Iceberg. Postgres is already the de facto standard.
The Lost Decade of Small Data
May 23, 2025 in Database
If DuckDB had launched in 2012, the great migration to distributed analytics might never have happened. Data isn't that big after all.
If DuckDB had launched in 2012, the great migration to distributed analytics might never have happened. Data isn't that big after all.
Scaling Postgres to the Next Level at OpenAI
May 19, 2025 in Database
At PGConf.Dev 2025, Bohan Zhang from OpenAI shared a session titled Scaling Postgres to the next level at OpenAI, giving us a peek into the database usage of a top-tier unicorn. “At OpenAl, we’ve proven that PostgreSQL can scale to support massive …
At PGConf.Dev 2025, Bohan Zhang from OpenAI shared a session titled Scaling Postgres to the next level at OpenAI, giving us a peek into the database usage of a top-tier unicorn. “At OpenAl, we’ve proven that PostgreSQL can scale to support massive …
How Many Shops Has etcd Torched?
May 07, 2025 in Database
Plenty. If you’re rolling your own Kubernetes, odds are you’ll crash because etcd ships with a 2 GB time bomb.
Plenty. If you’re rolling your own Kubernetes, odds are you’ll crash because etcd ships with a 2 GB time bomb.
Pigsty v3.5: 4K Stars, PG18 Beta, 421 Extensions
May 01, 2025 in Pigsty
Pigsty crosses 4K GitHub stars, adds PG18 beta support, pushes extensions to 421, ships new doc site, and completes OrioleDB/OpenHalo full-platform support.
Pigsty crosses 4K GitHub stars, adds PG18 beta support, pushes extensions to 421, ships new doc site, and completes OrioleDB/OpenHalo full-platform support.
In the AI Era, Software Starts at the Database
April 27, 2025 in Database
Future software = Agent + Database. No middle tiers, just agents issuing CRUD. Database skills age well, and PostgreSQL is poised to be the agent-era default.
Future software = Agent + Database. No middle tiers, just agents issuing CRUD. Database skills age well, and PostgreSQL is poised to be the agent-era default.
MySQL vs. PostgreSQL @ 2025
April 17, 2025 in Database
A 2025 reality check on where PostgreSQL stands relative to MySQL across features, performance, quality, and ecosystem.
A 2025 reality check on where PostgreSQL stands relative to MySQL across features, performance, quality, and ecosystem.
Postgres Extension Day - See You There!
April 09, 2025 in PostgreSQL
The annual PostgreSQL developer conference will be held in Montreal in May. Like the first PG Con.Dev, there's also an additional dedicated event - Postgres Extensions Day
The annual PostgreSQL developer conference will be held in Montreal in May. Like the first PG Con.Dev, there's also an additional dedicated event - Postgres Extensions Day
OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute Separation
April 06, 2025 in PostgreSQL
A PG kernel fork acquired by Supabase, claiming to solve PG's XID wraparound problem, eliminate table bloat issues, improve performance by 4x, and support cloud-native storage. Now part of the Pigsty family.
A PG kernel fork acquired by Supabase, claiming to solve PG's XID wraparound problem, eliminate table bloat issues, improve performance by 4x, and support cloud-native storage. Now part of the Pigsty family.