Planet PostgreSQL@planetpostgres

Blog entries from members of the PostgreSQL community

 Anywhere!
planet.postgresql.org
Joined June 2008
With the new API restrictions, we are no longer posting here. Please follow us on bsky.app/profile/planet.post… or on fosstodon.org/@planetpostgre…
1
21
2,089
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – new pg_get_*_ddl() functions postgr.es/p/8jg
2
11
1,538
warda bibi: The 1 GB Limit That Breaks pg_prewarm at Scale postgr.es/p/8jf

The 1 GB Limit That Breaks pg_prewarm at Scale | Stormatics

Learn how a 1 GB palloc() limit in PostgreSQL 16.8 breaks pg_prewarm autoprewarm at large shared_buffers sizes, causes crash loops, and why upgrading to 16.10 fixes it.

stormatics.tech
1
8
1,519
Jim Mlodgenski: pgcollection 2.0: Integer Keys, Range Deletes, and Oracle Parity postgr.es/p/8je
7
1,303
Vibhor Kumar: AI at the Edge, Truth in Postgres postgr.es/p/8f_
3
12
1,156
Lætitia AVROT (@l_avrot): pg_column_size(): What you see is not what you get postgr.es/p/8cM
9
1,139
Ahsan Hadi: Using the pgEdge MCP Server with a Distributed PostgreSQL Cluster postgr.es/p/8cL
9
1,191
Laurenz Albe: Schemas in PostgreSQL and Oracle: what is the difference? postgr.es/p/8cK

Schemas in PostgreSQL and Oracle: what is the difference?

This article describes how the database management systems Oracle and PostgreSQL implement the standard SQL concept "schema" differently.

cybertec-postgresql.com
3
18
1,220
Cornelia Biacsics: Contributions for week 13, 2026 postgr.es/p/806
1
9
977
David Wheeler (@theory): pg_clickhouse 0.1.10 postgr.es/p/7DT

pg_clickhouse 0.1.10

Hi, it’s me with another update to pg_clickhouse.

justatheory.com
12
1,206
Radim Marek: Don't let your AI touch production postgr.es/p/7DS

Don't let AI touch your production database

Most PostgreSQL MCP servers are connection wrappers or provider gateways. Neither warns an AI agent that its migration locks a 4M-row table. dryrun MCP does.

boringsql.com
1
1
14
1,120
Richard Yen: WAL as a Data Distribution Layer postgr.es/p/7DR
1
13
1,342
Lætitia AVROT (@l_avrot): PAX: The Storage Engine Strikes Back postgr.es/p/7DQ
1
8
1,043
Shaun Thomas: What is a Collation, and Why is My Data Corrupt postgr.es/p/7Ds
2
15
1,282
Pavel Stehule: Using non ACID storage as workaround instead missing autonomous transactions postgr.es/p/7A9
14
1,899
David Wheeler (@theory): pg_clickhouse 0.1.6 postgr.es/p/7A6
1
15
1,174
Elizabeth Garrett Christensen: Postgres Vacuum Explained: Autovacuum, Bloat and Tuning postgr.es/p/7wv
3
28
1,246
Antony Pegg: pgEdge MCP Server for Postgres Is Now GA. Here’s Why That Matters postgr.es/p/7A5
11
1,345
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OF postgr.es/p/7A4
1
11
1,123
Vibhor Kumar: pg_background v1.9: a calmer, more practical way to run SQL in the background postgr.es/p/7wA
14
1,079
Load more