Sammlung von Newsfeeds

Bruce Momjian: Postgres 19 Release Notes

Neues vom PostgreSQL Planet - 15. April 2026 - 23:15

I have just completed the first draft of the Postgres 19 release notes. It includes little developer community feedback and still needs more XML markup and links. This year I have created a wiki page explaining the process I use.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Online enabling and disabling of data checksums

Neues vom PostgreSQL Planet - 15. April 2026 - 20:05
On 3rd of April 2026, Daniel Gustafsson committed patch: Online enabling and disabling of data checksums   This allows data checksums to be enabled, or disabled, in a running cluster without restricting access to the cluster during processing.   Data checksums could prior to this only be enabled during initdb or when the cluster is … Continue reading "Waiting for PostgreSQL 19 – Online enabling and disabling of data checksums"

Tudor Golubenco: Introducing Xata OSS: Postgres platform with branching, now Apache 2.0

Neues vom PostgreSQL Planet - 15. April 2026 - 14:30
Xata core is now available as open source under the Apache 2 license. It adds copy-on-write branching, scale-to-zero compute to Postgres.

Ahsan Hadi: pgEdge Vectorizer and RAG Server: Bringing Semantic Search to PostgreSQL (Part 2)

Neues vom PostgreSQL Planet - 15. April 2026 - 8:29

In my previous blog, I walked through setting up the pgEdge MCP Server with a distributed PostgreSQL cluster, and connecting Claude to live database data through natural language. In this blog I want to look at a different problem: how do you build AI-powered search over your own content, without adding a separate vector database to your infrastructure?This is where the pgEdge Vectorizer and RAG Server come in.

A 6502 CPU emulator entirely in Postgres

Postgres Weekly - 15. April 2026 - 2:00

#​644 — April 15, 2026

Web Version

Postgres Weekly

Lætitia AVROT: Postgres performance regression: are we there yet?

Neues vom PostgreSQL Planet - 15. April 2026 - 2:00
Every year, PostgreSQL gets faster. Researchers benchmarking the optimizer from version 8 through 16 found an average 15% performance improvement per major release. That’s a decade of consistent, measurable progress. The project has been doing this since 1996. So when a headline claimed Linux 7.0 just halved PostgreSQL throughput, DBAs, Sys Admins, and DevOps started panicking (in particular, those working with Ubuntu 26.04 LTS which plan to ship Linux kernel 7.

Vibhor Kumar: AI-Ready PostgreSQL 18 Is Out: Why AI Applications Win or Lose at the Seams

Neues vom PostgreSQL Planet - 15. April 2026 - 1:29

Most AI projects do not fail because the model is weak. They fail because the seams around the model break under real-world constraints such as data truth, governance, and production reality.

Andreas Scherbaum: PGConf India 2026 - Review

Neues vom PostgreSQL Planet - 15. April 2026 - 0:00
This was my first time attending PGConf.India. That is a conference I wanted to visit for quite a while, heard good things about the it, but never had a chance before. During past years it overlapped with another conference I’m attending in Germany - but this year it worked out! Overall this is the 9th Indian PostgreSQL Conference, with no signs of slowing down. Stage at PGConf India 2026 The conference is well attended, and very vibrant.

Gabriele Bartolini: Owning the pipe: physical replication, cloud neutrality, and the escape from DBaaS lock-in

Neues vom PostgreSQL Planet - 14. April 2026 - 2:32

This article examines how managed database services deliberately suppress access to the physical replication stream, turning operational convenience into permanent lock-in. It makes the case for a cloud-neutral stack — PostgreSQL, Kubernetes, and CloudNativePG — as the only architecture that returns full operational sovereignty to the organisation that owns the data.

Ming Ying: ParadeDB is Officially on Railway

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

David Wheeler: pg_clickhouse 0.2.0

Neues vom PostgreSQL Planet - 14. April 2026 - 0:22

In response to a generous corpus of real-world user feedback, we’ve been hard at work the past week adding a slew of updates to pg_clickhouse, the query interface for ClickHouse from Postgres. As usual, we focused on improving pushdown, especially for various date and time, array, and regular expression functions.

Postgres in Production Special Series: What pg_stat_statements Is and Isn't (Part 1)

Pganalyze Blog RSS Feed - 13. April 2026 - 14:00

In this special series of “Postgres in Production”, we take a deep dive into pg_stat_statements — the essential Postgres extension for tracking query performance. In Part 1, Ryan Booz covers what pg_stat_statements is, how to enable it, what it tracks, and critically, what it doesn’t track and why that matters for your monitoring setup.

Cornelia Biacsics: Contributions for week 14, 2026

Neues vom PostgreSQL Planet - 13. April 2026 - 10:19

The Toulouse PostgreSQL User Group met on April 7, 2026 organized by

  • Geoffrey Coulaud
  • Xavier SIMON
  • Jean-Christophe Arnu

Speakers:

Richard Yen: Understanding PostgreSQL Wait Events

Neues vom PostgreSQL Planet - 13. April 2026 - 10:00
Introduction

One of the most useful debugging tools in modern PostgreSQL is the wait event system. When a query slows down or a database becomes CPU bound, a natural question is: “What are sessions actually waiting on?” Postgres exposes this information through the pg_stat_activity view via two columns:

wait_event_type wait_event

These fields reveal what the backend process is blocked on at a given moment. Among the different wait types, one category tends to cause confusion:

Jeremy Schneider: Zero autovacuum_cost_delay, Write Storms, and You

Neues vom PostgreSQL Planet - 13. April 2026 - 7:10

A few days ago, Shaun Thomas published an article over on the pgEdge blog called [Checkpoints, Write Storms, and You]. Sadly a lot of corporate blogs don’t have comment functionality anymore.

Ruohang Feng: 504 Extensions: Expand the PostgreSQL Landscape

Neues vom PostgreSQL Planet - 13. April 2026 - 2:00
One GitHub issue turned into an extension sprint. 32 new additions, 504 in total, say a lot about where PostgreSQL is headed.

Vibhor Kumar: column_encrypt v4.0: A Simpler, Safer Model for Column-Level Encryption in PostgreSQL

Neues vom PostgreSQL Planet - 12. April 2026 - 22:47

There is a point in every security tool’s life where adding one more feature is less important than removing one more obstacle.

That is what makes column_encrypt v4.0 interesting.

Waiting for Postgres 19: Reduced timing overhead for EXPLAIN ANALYZE with RDTSC

Pganalyze Blog RSS Feed - 11. April 2026 - 14:00

In today’s E122 of “5mins of Postgres” we’re talking about the upcoming Postgres 19 release, and how a change in the Postgres instrumentation handling reduces overhead of timing measurements in EXPLAIN ANALYZE using the RDTSC instruction, and why this will allow turning on auto_explain.log_timing for more workloads.

Waiting for Postgres 19: Reduced timing overhead for EXPLAIN ANALYZE with RDTSC

Pganalyze Blog RSS Feed - 11. April 2026 - 14:00
In today’s E122 of “5mins of Postgres” we're talking about the upcoming Postgres 19 release, and how a change in the Postgres instrumentation handling reduces overhead of timing measurements in EXPLAIN ANALYZE using the RDTSC instruction, and why this will allow turning on auto_explain.log_timing for more workloads.

Lukas Fittl: Waiting for Postgres 19: Reduced timing overhead for EXPLAIN ANALYZE with RDTSC

Neues vom PostgreSQL Planet - 11. April 2026 - 14:00
In today’s E121 of “5mins of Postgres” we're talking about the upcoming Postgres 19 release, and how a change in the Postgres instrumentation handling reduces overhead of timing measurements in EXPLAIN ANALYZE using the RDTSC instruction, and why this will allow turning on for more workloads. We dive into the recently committed change that I (Lukas) authored together with Andres Freund and David Geier. See the full transcript with examples below. Share this episode: Click here to share this…

Seiten