PostgreSQL Technical Articles

Sunil Kamath

Improving Lakebase Postgres Compute Cache on Neon, Part 1

On large fixed-size Lakebase Postgres computes on Neon, most available machine memory is now allocated to Postgres shared buffers, backed by huge pages. This change keeps hot page…

Read the Blog

Slava Sarzhan

Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging

Percona Operator for PostgreSQL 3.1.0 introduces three major features. First, transparent data encryption via pg_tde encrypts tables, indexes, and WAL on disk, using HashiCorp Vau…

Read the Blog

Percona Team

Meet pgstef: Why Stefan Fercot Joined Percona, and Why You Should Find Him at Percona Live Amsterdam

Stefan Fercot (pgstef), a long-time pgBackRest advocate and PostgreSQL community contributor, has joined Percona as a senior software engineer focused on pgBackRest development. P…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Implement waiting for wal lsn replay: reloaded

The thread discusses implementing a "WAIT FOR WAL LSN replay" feature in PostgreSQL. Alexander Korotkov revised patch 0001, making several improvements: clarifying documentation a…

Read Discussion

[PATCH] Release replication slot on error in SQL-callable slot functions

The patch discussion addresses releasing replication slots on error in SQL-callable slot functions. A key design question concerns subtransaction (subxact) boundaries: when a slot…

Read Discussion

Rename PqMsg_Progress to PqMsg_ParallelWorkerProgress

Sami Imseih proposes renaming the protocol message constant `PqMsg_Progress` to `PqMsg_ParallelWorkerProgress`. The 'P' message was added for parallel index progress reporting, bu…

Read Discussion

Offline data checksum changes can cause incorrect checksum state on standbys

Daniel Gustafsson submitted v14 of a patch addressing documentation issues related to offline data checksum changes and their effect on standby checksum state. Following feedback…

Read Discussion

Speed up COPY FROM text/CSV parsing using SIMD

The thread concerns a patch to speed up COPY FROM text/CSV parsing using SIMD instructions. A regression of 1–2% on TEXT-wide inputs was identified relative to the current master.…

Read Discussion

CREATE SCHEMA ... CREATE DOMAIN support

The discussion centers on reverting v19 changes related to `CREATE SCHEMA` subcommand support. Commit `a9c350d9e` silently changed the meaning of existing `CREATE SCHEMA` statemen…

Read Discussion

Industry News

techcrunch.com

Harvey hits $5.5B valuation, months after reaching $11B

Harvey, a legal AI startup, has reached a $15.5 billion valuation, nearly doubling its worth in just nine months after previously hitting an $11 billion valuation. The rapid growt…

techcrunch.com

Anthropic Researcher Resigns Over AI Extinction Risks, Urges Lab Pacing Agreements

Jacob Coxon, a researcher at Anthropic, has resigned citing fears that self-improving AI could lead to human extinction. Coxon's departure highlights deepening internal tensions a…

Social Media Updates

Your business deserves a robust database solution that ensures compliance and high performance across all platforms.

CYBERTEC PostgreSQL Support Services offers database support packages tailored for both large enterprises and small to medium-sized businesses. The service emphasizes rapid respon…

What happens when thousands of devices start streaming events at once?

This demo presents a simplified real-time IoT architecture capable of handling thousands of concurrent device events and live sensor data from phones worldwide. The stack relies o…

Embedding an AI/BI Dashboard is easy.

Embedding an AI/BI dashboard is straightforward, but ensuring each viewer sees only their permitted data is more complex. This guide covers how to securely share a single dashboar…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates