@planetpostgres

Blog entries from members of the PostgreSQL community

 Anywhere!
planet.postgresql.org
Joined June 2008
  • Tweets13.9K
  • Following1
  • Followers43.6K
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
23
2,151
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – new pg_get_*_ddl() functions postgr.es/p/8jg
2
13
1,591
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
9
1,567
Jim Mlodgenski: pgcollection 2.0: Integer Keys, Range Deletes, and Oracle Parity postgr.es/p/8je
8
1,327
Vibhor Kumar: AI at the Edge, Truth in Postgres postgr.es/p/8f_
3
13
1,187
Lætitia AVROT (@l_avrot): pg_column_size(): What you see is not what you get postgr.es/p/8cM
9
1,159
Ahsan Hadi: Using the pgEdge MCP Server with a Distributed PostgreSQL Cluster postgr.es/p/8cL
9
1,206
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,237
Cornelia Biacsics: Contributions for week 13, 2026 postgr.es/p/806
1
9
985
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,214
Radim Marek: Don't let your AI touch production postgr.es/p/7DS
1
1
14
1,128
Richard Yen: WAL as a Data Distribution Layer postgr.es/p/7DR
1
13
1,350
Lætitia AVROT (@l_avrot): PAX: The Storage Engine Strikes Back postgr.es/p/7DQ
1
8
1,051
Shaun Thomas: What is a Collation, and Why is My Data Corrupt postgr.es/p/7Ds
2
15
1,291
Pavel Stehule: Using non ACID storage as workaround instead missing autonomous transactions postgr.es/p/7A9
14
1,906
David Wheeler (@theory): pg_clickhouse 0.1.6 postgr.es/p/7A6

pg_clickhouse 0.1.6

Another bug fix and pushdown-improving release of the foreign data wrapper.

justatheory.com
1
15
1,180
Elizabeth Garrett Christensen: Postgres Vacuum Explained: Autovacuum, Bloat and Tuning postgr.es/p/7wv
3
28
1,253
Antony Pegg: pgEdge MCP Server for Postgres Is Now GA. Here’s Why That Matters postgr.es/p/7A5
11
1,351
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OF postgr.es/p/7A4
1
11
1,132
Vibhor Kumar: pg_background v1.9: a calmer, more practical way to run SQL in the background postgr.es/p/7wA
14
1,084
Load more