Sammlung von Newsfeeds

Christophe Pettus: All Your GUCs in a Row: backtrace_functions

Neues vom PostgreSQL Planet - vor 18 Stunden 13 Minuten
Debug PostgreSQL errors by capturing C-level stack traces for specific internal functions.

Christophe Pettus: Eleven CVEs Walk Into a Release

Neues vom PostgreSQL Planet - 14. Mai 2026 - 20:00
PostgreSQL 18.4, 17.10, 16.14, 15.18, and 14.23 are out as of May 14, 2026. The release fixes eleven security issues and more than sixty bugs. That is not a typo. Eleven CVEs is the largest single-release security batch I can remember, and three of them are CVSS 8.8 with practical exploitation pa…

Christophe Pettus: PARTITION MERGE/SPLIT, Once More With Locking

Neues vom PostgreSQL Planet - 14. Mai 2026 - 17:00
PostgreSQL 19 brings back MERGE PARTITIONS and SPLIT PARTITION—but simpler and safer than the first attempt.

Henrietta Dombrovskaya: Prairie Postgres May meetup: the Mythical data Warehouse

Neues vom PostgreSQL Planet - 14. Mai 2026 - 14:49

Yesterday, we had our first meetup at our new venue, which we hope will become our permanent home: the Chicago Innovations Center at 1 W. Monroe. We had the pleasure of having Elizabeth Christensen from Snowflake, who delivered a talk pg_lake: Unifying transactional and analytical data with Postgres.

I find the topic exceptionally valuable, and I was delighted when Elizabeth suggested it. Below are some photos and a presentation recording.

Many thanks to:

Christophe Pettus: All Your GUCs in a Row: backslash_quote

Neues vom PostgreSQL Planet - 14. Mai 2026 - 3:00
A 2006 SQL injection vulnerability and multibyte character encodings created `backslash_quote`, a GUC parameter that remains in PostgreSQL for backward…

Robins Tharakan: Postgres May 2026 Security Update: 11 CVEs, All Versions Affected

Neues vom PostgreSQL Planet - 13. Mai 2026 - 17:28

It's that time again. The upcoming Postgres v18.4 release (along with minor releases for all Major versions) has dropped some serious hints in the git logs, and it's bringing a significant payload of CVE tagged patches. As a seasoned Postgres end-user and an erstwhile DBA, whenever I see a flurry of high-vulnerability security commits, I immediately start recommending that customers begin planning their patching cycles.

Christophe Pettus: Twenty Years in pgcrypto

Neues vom PostgreSQL Planet - 13. Mai 2026 - 17:00
A heap buffer overflow in pgcrypto's OpenPGP code lurked for two decades—until a December 2025 exploit made it real.

Jimmy Angelakos: pg_statviz 1.0 released with AI-powered analysis

Neues vom PostgreSQL Planet - 13. Mai 2026 - 14:37

I'm excited to announce release 1.0 of pg_statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics.

Gabriele Bartolini: CNPG Recipe 24 - Migrating from Crunchy PGO to PostgreSQL 18 with CloudNativePG

Neues vom PostgreSQL Planet - 13. Mai 2026 - 12:21

A step-by-step guide to migrating a PostgreSQL 17 cluster managed by Crunchy PGO v6 to PostgreSQL 18 under CloudNativePG. Two paths are covered: a fully declarative offline migration using CloudNativePG’s built-in pg_dump import, and an online migration using native PostgreSQL logical replication for a near-zero-downtime cutover.

Cornelia Biacsics: Contributions for week 18, 2026

Neues vom PostgreSQL Planet - 13. Mai 2026 - 8:10

PGConf Belgium took place on 5 May 2026, organized by Wim Bertels, An Vercammen, and Grégory Gioffredi , who served also at the talk selection team.

Speaker:

Christophe Pettus: All Your GUCs in a Row: backend_flush_after

Neues vom PostgreSQL Planet - 13. Mai 2026 - 3:00
PostgreSQL's complicated relationship with the Linux page cache spawns four GUCs to manage writeback—and backend_flush_after is the conservative one.

Don't pretend your Postgres views are tables

Postgres Weekly - 13. Mai 2026 - 2:00

#​648 — May 13, 2026

Web Version

Postgres Weekly

Strong Views on Postgres VIEWs — Why views are clean to use but painful to change in Postgres, with a tour of how they work under the hood and what’s missing from ALTER VIEW. Surprisingly, the mechanism that would fix it already exists inside pg_dump…

Radim Marek

Christophe Pettus: Snowflake Postgres, Lakebase, HorizonDB: Picking the Lock-In You Want

Neues vom PostgreSQL Planet - 12. Mai 2026 - 17:00
Three major cloud platforms just shipped Postgres with custom storage engines and scale-out architectures.

Christophe Pettus: Managed Postgres, Examined: Google Cloud SQL for PostgreSQL

Neues vom PostgreSQL Planet - 12. Mai 2026 - 15:00
Google's managed PostgreSQL returns to first principles: a conventional instance on a VM with a regional disk, plus a distinctive data cache on Enterprise Plus…

Kai Wagner: Two projects, one mission - hackorum and pginbox join forces

Neues vom PostgreSQL Planet - 12. Mai 2026 - 13:15

Last week, Zsolt and I jumped on a call with someone who had been building something remarkably similar to what we had been working on, completely independently. That someone is Jack Bonatakis, the creator of pginbox.dev, and that call turned into one of the most energizing conversations we’ve had since launching hackorum.dev.

Christophe Pettus: All Your GUCs in a Row: autovacuum_worker_slots

Neues vom PostgreSQL Planet - 12. Mai 2026 - 3:00
PostgreSQL 18 splits autovacuum configuration to finally let you tune worker concurrency without restarting.

Ming Ying: ParadeDB is Officially on Render

Neues vom PostgreSQL Planet - 12. Mai 2026 - 2:00
Deploy ParadeDB on Render with one click. Full-text search, vector search, and hybrid search over Postgres — now available on your favorite cloud platform.

David Wheeler: What’s New in pg_clickhouse

Neues vom PostgreSQL Planet - 11. Mai 2026 - 22:24

Bit of a news catchup on the pg_clickhouse project.

What’s New

First up, a couple weeks ago the ClickHouse Blog published What’s New in pg_clickhouse, in which I covered various improvements to the extension:

SHRIDHAR KHANAL: SSL in PostgreSQL

Neues vom PostgreSQL Planet - 11. Mai 2026 - 17:09

A beginner’s guide to encrypting your database connections

“’SSL is enabled’ and ‘SSL is actually working’ are two very different things.”

Christophe Pettus: The wal_level You Set Is Not the wal_level You Get

Neues vom PostgreSQL Planet - 11. Mai 2026 - 17:00
PostgreSQL 19 finally lets wal_level adapt dynamically to your actual replication slots, eliminating the always-on WAL cost of logical standby insurance.

Seiten