Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 1 Minute

Mehmet Ince: Part 3/6 | How I Ended Up Turning a 22-Year-Old PostgreSQL Type-Confusion Primitive into RCE (CVE-2026-6460)

9. November 2026 - 23:07

If you had told me in April 2026 one question “Mehmet, can we use managed PostgreSQL for this project?” would send me into the deepest rabbit hole of my life, I would have laughed.

Months later, I finally found the bottom of that rabbit hole. It was a 22-year-old zero-day in PostgreSQL core.

In this blog post you will read a story of how I ended up uncovering a new class of type-confusion vulnerabilities in PostgreSQL.

Hubert 'depesz' Lubaczewski: What LLMs do to PostgreSQL and DBAs

9. November 2026 - 21:54
Recently there has been some discussion about why so many features got reverted from PostgreSQL 19. I've read blogposts, talked with people, spent some time thinking. And it got me curious. I noticed lately that there is more mails to pgsql-bugs mailing list – basically reports of bugs, or conversations about them. I also noticed … Continue reading "What LLMs do to PostgreSQL and DBAs"

Alicja Kucharczyk: What your PostgreSQL needs before Black Friday

9. November 2026 - 17:30

On Black Friday, many more people use your application at the same moment. For PostgreSQL that means more connections, more sessions that want the same rows, and more cleanup work and transaction log in the same hour. This article shows which limits a peak usually reaches first, which of them a bigger server does not remove, how to check each one on your own server with plain SQL, and which changes need a restart and therefore belong before your change freeze.

Cornelia Biacsics: Contributions for week 44

9. November 2026 - 9:58

On 4 November, the PostgreSQL Meetup Group Berlin met.

Organized by:

  • Andreas Scherbaum
  • Daria Aleshkova
  • Oleksii Kliukin
  • Sergey Dudoladov

Speakers:

Richard Yen: An Index Scan Is Only Half the Story

9. November 2026 - 6:00

Also posted in Microsoft Blog for PostgreSQL

Same Query, Same Index, Different Performance

I recently worked with a customer planning a migration from on-premises PostgreSQL to Azure Database for PostgreSQL. During performance testing, they noticed something troubling: a query that completed in tens of milliseconds would now take 1-2 seconds in the Azure environment being evaluated.

Maki Majima: Two migrations collide: one loud failure, one silent one

9. November 2026 - 1:00

In the previous post I argued that migrations don’t earn Git’s protections by being made of files: two incompatible schema changes live in two separate migration files, so there is nothing to textually conflict, and both branches merge clean. The repository accepts the pair without comment.

Chris van Eijk: json vs jsonb in PostgreSQL: size and speed, measured

8. November 2026 - 23:30
json vs jsonb in PostgreSQL 17 and 18, measured on six document shapes: when jsonb is 23% smaller or 41% larger, read speed, GIN, and what it changes.

Vadim Yatsenko: The Server-First Reader Pool: Exact Connection Reuse and Hot-Path Performance

8. November 2026 - 12:30
Once a proxy decides which replica should serve a read, it still has to find or create a connection to that replica. This article is about how Polar Proxy organizes its reader connection pool and trims the hot path so that connection handling stops competing with the actual work of answering queries.

Hollis Varden: Thirteen small measurements on PostgreSQL 18

8. November 2026 - 1:00

These are thirteen things I measured in one sitting. Each one is small. A few of them surprised me anyway.

Setup

PostgreSQL 18.6, built from source, default settings (work_mem 4MB, shared_buffers 128MB, 2 parallel workers per gather). MacBook Air M5, 10 cores, 24 GB RAM, internal SSD. This is a different machine from my earlier posts, so don't compare times across posts.

Dave Stokes: Is PostgreSQL Really Winning Part 2: The Evidence Beyond the Rankings

7. November 2026 - 18:11

 My last post leaned hard on the DB-Engines ranking, and I admitted that ranking measures popularity, not installed base or revenue. Several of you called me on that, politely and otherwise. Fair enough.

Christophe Pettus: All Your GUCs in a Row: scram_iterations

7. November 2026 - 3:00
`scram_iterations` embeds itself in each password when set and stays there forever, making it a per-password property masquerading as a server setting. (I consult on PostgreSQL through PGX Inc..)

Chris Travers: PostgreSQL, NUMA, and the Cloud

6. November 2026 - 17:11
PostgreSQL and NUMA, Part 4 of 4 This series covers the specifics of running PostgreSQL on large systems with many processors. My experience is that people spend months often learning the basics when confronted with the problem. This series tries to dispel these difficulties by providing a clear background into the topics in question.

Ruohang Feng: PostgreSQL Ecosystem Update: The AI Bug-Hunting Crunch

6. November 2026 - 1:00
AI-driven vulnerability discovery has open-source maintainers scrambling to ship patches, delaying PostgreSQL 19 and triggering a wave of extension releases. This post covers OrioleDB 1.10.1, DuckDB 2.0, vector and experimental extensions, full-history Chinese documentation translations, and three native macOS tools: Barn, Crib, and CapsLock.

Ahsan Hadi: Zero Downtime In-Place Major PostgreSQL Upgrades on a Distributed PostgreSQL Cluster

5. November 2026 - 17:35

In my last post I walked through a rolling major version upgrade: add a brand new node on the new version, let it join the Spock cluster, retire the old node. It works well, but it assumes you can stand up an extra server for every node you need to upgrade. A lot of customers I talk to cannot. Either the hardware is not there, or the database is too big to hold a second full copy.For them there is a second option. Upgrade each node in place with .

SHRIDHAR KHANAL: PostgreSQL Minor Version Upgrade on RHEL 9: A Step-by-Step Guide with Rollback

5. November 2026 - 14:47
Key Takeaways
  • A minor upgrade, such as 15.13 to 15.19, only replaces the binaries. The data directory stays as it is, so there is no pg_upgrade, dump and restore, or new cluster.
  • The upgrade command takes seconds.

Nikolay Samokhvalov: UUIDv4 vs UUIDv7: what a random primary key costs in Postgres

5. November 2026 - 13:00
Same table, same insert stream, three primary keys on Postgres 18. At 100M rows, UUIDv4 inserted at 0.62 to 0.69 of the rate of an ordered key on the same server, and wrote 1.5 to 1.9 times the WAL per row. Where the cost starts, and what it is made of.

Ruohang Feng: Taking Over Another PostgreSQL Extension: vchord Yesterday, pg_mooncake Today

5. November 2026 - 1:00
A day after taking over VectorChord, I forked pg_mooncake—restoring its documentation and blog from the Internet Archive, updating it for pg_duckdb 1.2 and pgrx 0.19.3, and shipping packages for Pigsty users.

Bruce Momjian: New Presentation

4. November 2026 - 18:00

I just gave a new presentation at FOSS4G North America titled Can AI Write SQL? The talk is a follow-up to my Building an Mcp Server Using Postgres talk, and explores how well AI can write SQL queries, and how to help AI be more effective.

Ilya Kosmodemiansky: The “default” postgresql.conf

4. November 2026 - 15:54
Part 1 of 4: how PostgreSQL configuration works, and connection settings

pg_settings, reload versus restart, max_connections, reserved connections and TCP keepalives

Seiten