@planetpostgres profile picture
Planet PostgreSQL @planetpostgres

Blog entries from members of the PostgreSQL community

Joined June 2008
  • Tweets 13,911
  • Following 1
  • Followers 44,015
Photos and videos
Pinned Tweet
Planet PostgreSQL@planetpostgres
Apr 10
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
1,819
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – new pg_get_*_ddl() functions postgr.es/p/8jg
2
11
1,297
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,316
Jim Mlodgenski: pgcollection 2.0: Integer Keys, Range Deletes, and Oracle Parity postgr.es/p/8je
7
1,171
Vibhor Kumar: AI at the Edge, Truth in Postgres postgr.es/p/8f_
3
12
1,051
Lætitia AVROT (@l_avrot): pg_column_size(): What you see is not what you get postgr.es/p/8cM
9
1,074
Ahsan Hadi: Using the pgEdge MCP Server with a Distributed PostgreSQL Cluster postgr.es/p/8cL
9
1,122
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,162
Cornelia Biacsics: Contributions for week 13, 2026 postgr.es/p/806
1
9
925
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,152
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,082
Richard Yen: WAL as a Data Distribution Layer postgr.es/p/7DR
1
14
1,315
Lætitia AVROT (@l_avrot): PAX: The Storage Engine Strikes Back postgr.es/p/7DQ
1
8
1,019
Shaun Thomas: What is a Collation, and Why is My Data Corrupt postgr.es/p/7Ds
2
15
1,258
Pavel Stehule: Using non ACID storage as workaround instead missing autonomous transactions postgr.es/p/7A9
14
1,871
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,147
Elizabeth Garrett Christensen: Postgres Vacuum Explained: Autovacuum, Bloat and Tuning postgr.es/p/7wv
3
28
1,228
Antony Pegg: pgEdge MCP Server for Postgres Is Now GA. Here’s Why That Matters postgr.es/p/7A5
11
1,325
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OF postgr.es/p/7A4
1
11
1,104
Vibhor Kumar: pg_background v1.9: a calmer, more practical way to run SQL in the background postgr.es/p/7wA

pg_background v1.9: a calmer, more practical way to run SQL in the background

pg_background gives PostgreSQL a cleaner way to run SQL in the background while keeping the calling session free. This post explores what the extension does, why teams use it for maintenance, audit…

vibhorkumar.wordpress.com
14
1,062
Load more