PostgreSQL Technical Articles

A step-by-step practical guide to seamlessly improve your database security

The linked article from Postgres Professional offers a practical, step-by-step guide for improving PostgreSQL database security. While the content snippet is not available, the ti…

Read the Blog

Hans-Jürgen Schönig

Philosophy behind pg_hardstorage

CYBERTEC has released pg_hardstorage v1.0, an open-source PostgreSQL backup tool under Apache 2.0 with no enterprise tier or CLA. It streams WAL via the native replication protoco…

Read the Blog

www.postgresql.org

PostgreSQL 19 Beta 2 Released!

PostgreSQL Global Development Group has released PostgreSQL 19 Beta 2, available for download and testing. This release includes fixes since Beta 1: a regression in vacuumdb --ana…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Remove getpgusername()

The thread discusses removing the `getpgusername()` function from PostgreSQL. Michael Paquier identifies it as a historical artifact and proposes cleaning it up from `pg_proc.dat`…

Read Discussion

pg19b1: TRAP: failed Assert("pgstat_bktype_io_stats_valid(bktype_shstats, MyBackendType)")

A crash in PostgreSQL 19 beta1 is being discussed, triggered by a failed assertion in `pgstat_bktype_io_stats_valid()` during parallel worker exit. The bug, introduced by commit `…

Read Discussion

Fix publisher-side sequence permission reporting

A bug was fixed where a NULL privilege value from `has_sequence_privilege()` — returned when a sequence is dropped concurrently after being identified in a catalog snapshot — was…

Read Discussion

Why clearing the VM doesn't require registering vm buffer in wal record

Melanie Plageman recently pushed commits across multiple branches related to changes in how VM (visibility map) clearing interacts with WAL records. Fujii Masao raised a concern a…

Read Discussion

ci: namespace ccache by PostgreSQL major version

The discussion addresses a CI failure caused by GitHub Actions restoring a ccache across a PostgreSQL major version bump, resulting in incompatible shared libraries. Nazir Bilal Y…

Read Discussion

WAL compression setting after PostgreSQL LZ4 default change

The discussion centers on changing the behavior of `wal_compression = 'on'` in PostgreSQL. Currently, `'on'` maps to `pglz`, the only algorithm available before PG 15. The proposa…

Read Discussion

Industry News

techcrunch.com

Uber's $14.8B Acquisition of Delivery Hero to Nearly Double Global Footprint

Uber has agreed to acquire Delivery Hero in a $14.8 billion all-stock deal that would nearly double the company's global footprint. The transaction would combine the two companies…

techcrunch.com

Moonshot's Kimi K3 Expected to Rival Anthropic's Opus 4.8 as Largest Open AI Model from China

According to the Financial Times, Moonshot's upcoming Kimi K3 model is set to become the largest open AI model from China, with a parameter count estimated between 2 trillion and…

techcrunch.com

Apple Intelligence Approved for Launch in China with Alibaba and Baidu

Apple Intelligence has received approval to launch in China through partnerships with Alibaba and Baidu. The deal, which had been rumored to be in the works, marks a significant s…

Social Media Updates

Genie One is now available on iOS and Android, bringing the data-smart AI coworker wherever business decisions happen.

Genie One is now available on iOS and Android, allowing business users to access Databricks' AI assistant from mobile devices. Users can chat with Genie, explore dashboards, and a…

Into Postgres, agentic AI, open source tooling, distributed databases, or just building things with data?

A video series covering PostgreSQL and related data engineering topics. Featured content includes a demo of the pgEdge MCP Server for querying PostgreSQL through Claude Code or Cu…

⚡ Lakebase vs Lakehouse in < 90 seconds.

Michael Armbrust, Distinguished Engineer at Databricks, explains the difference between Lakehouse and Lakebase. Lakehouse addressed analytics workloads by separating compute and s…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates