Issue 645 - A Kafka-like pure SQL queue for Postgres by ~postgresweekly

E.1. Release 19

https://www.postgresql.org/docs/devel/release-19.html

📝 The First Draft of the PostgreSQL 19 Release Notes — Bruce has just completed the first, bulletpoint-heavy draft of the release notes for Postgres 19, targeted to land this September with a beta expected in the coming months.

4 months ago

Xata - open source Postgres platform with CoW branching by Tudor Golubenco

https://xata.io/blog/open-source-postgres-branching-copy-on-write

Introducing Xata OSS: A Postgres Platform with Branching, Now Apache 2.0 — Xata has made the core technology of its Postgres platform open source. You get copy-on-write branching at the storage layer that clones databases in seconds, scale-to-zero for inactive branches, while still having standard Postgres underneath.

4 months ago

Postgres performance regression: are we there yet? | My DBA Notebook

https://mydbanotebook.org/posts/postgres-performance-regression-are-we-there-yet/

📉 Investigating the Linux 7.0 Postgres Throughput Regression — We recently featured an article about how Linux 7.0 was affecting Postgres performance on certain setups. Lætitia digs into what the actual issue is, who’s affected (very few of us!) and what to keep in mind when you upgrade.

4 months ago

How Postgres CTIDs Gave Me a 30x Speedup on Processing 200 Million Rows

https://connorhallman.com/blog/ctid-batch-processing

How CTIDs Gave Me a 30x Speedup on Processing 200 Million Rows — A look at where index scans can fail at scale on large static tables, how the internal ctid (physical row address) enables true sequential I/O, and a full implementation with visualizations of the access pattern difference.

#postgresql #performance #big-data #dotnet

4 months ago

When upserts don't update but still write: Debugging Postgres performance at scale | Datadog

https://www.datadoghq.com/blog/engineering/debugging-postgres-performance/

When Upserts Don't Update But Still Write — How Datadog traced doubled disk writes and quadrupled WAL syncs to a surprising behavior: ON CONFLICT DO UPDATE locks the conflicting row even when the WHERE condition means nothing is actually updated.

#postgresql #database

4 months ago

GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.

https://github.com/NikolayS/pgque

PgQue: A Pure SQL + PL/pgSQL Zero-Bloat Postgres Queue — From a long-time Postgres contributor comes a modern version of Skype’s PgQ in ‘one SQL file + pg_cron’ form. Architecturally closer to Kafka than a typical job queue with zero event-table bloat, native fan-out, and no SKIP LOCKED.

4 months ago

Apache Cloudberry (Incubating) | Apache Cloudberry (Incubating)

https://cloudberry.apache.org/

Apache Cloudberry 2.1: A Postgres-Based MPP Database — An MPP (Massively Parallel Processing) database splits data and query execution across many nodes; a big win for analytics workloads. Cloudberry carries on work started with Greenplum, but on a more modern Postgres kernel. GitHub repo.

4 months ago

GitHub - samirketema/pg_roast: A Postgres extension that audits your database and harshly judges everything it finds.

https://github.com/samirketema/pg_roast

🔥 pg_roast: An Extension That Audits and 'Roasts' Your Database — Built upon principles from the book PostgreSQL Mistakes and How to Avoid Them.

4 months ago