PostgreSQL Technical Articles

Carlota Soto

Inside LuBot's database-per-tenant architecture

LuBot adopted a database-per-tenant architecture using Neon, achieving full tenant isolation with a dedicated Postgres database provisioned automatically at payment time. The impl…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Trying to break online checksums with LLMs

The discussion concerns the online checksums feature and how it handles orphaned files in the PostgreSQL data directory. Robert Haas argues that orphaned files are a normal operat…

Read Discussion

Optimize UUID parse using SIMD

A patch to optimize UUID parsing using SIMD instructions has gone through multiple review iterations (at least v6). Bharath Rupireddy reviewed the v6 patch, confirmed that comment…

Read Discussion

Make pg_prewarm, autoprewarm yield for waiting DDL

The patch series aims to make pg_prewarm and autoprewarm yield when DDL operations are waiting for locks. Reviewer Palak Chaturvedi identified two issues in v3: first, patch 0001…

Read Discussion

Fix unnecessary shared memory page allocation in CalculateShmemSize()

Chao Li reported a long-standing bug in `CalculateShmemSize()` where an unconditional `add_size()` call always adds 8192 bytes even when the size is already a multiple of 8192, re…

Read Discussion

Report index currently being vacuumed in pg_stat_progress_vacuum

The discussion centers on a patch to report the index currently being vacuumed in pg_stat_progress_vacuum, including progress details for parallel vacuum workers. Masahiko Sawada…

Read Discussion

Use WALReadFromBuffers in more places

Bharath Rupireddy reports a CF bot failure in the `001_rep_changes.pl` TAP test caused by the logical walsender reading all WAL from WAL buffers, so the disk read path was never h…

Read Discussion

Industry News

techcrunch.com

OpenAI Acquires Smartphone Camera Maker Glass Imaging for $300 Million

OpenAI has acquired Glass Imaging, a smartphone camera technology company, for approximately $300 million, according to reports. Glass Imaging was founded by two former Apple engi…

techcrunch.com

AI Infrastructure Startup Cornelis Raises $205M to Challenge Nvidia

AI infrastructure company Cornelis has raised $205 million in funding, positioning itself as a challenger to Nvidia's dominance in the AI hardware space. Alongside the funding ann…

techcrunch.com

Superhuman Acquires YC-Backed AI Notetaker Fathom

Email productivity platform Superhuman has acquired Fathom, a Y Combinator-backed AI meeting notetaker, as productivity software companies race to integrate agentic AI capabilitie…

Social Media Updates

Running PostgreSQL in Kubernetes is a different discipline from running it on a server.

A containerized deployment course for PostgreSQL on Kubernetes runs September 28 to 30, with three live online sessions daily from 9:00 to 14:00 CEST. Topics include Kubernetes ar…

Highly available PostgreSQL usually means leader election, streaming replicas, automatic failover, health checks, and a lot of careful wiring.

Setting up highly available PostgreSQL traditionally requires configuring leader election, streaming replicas, automatic failover, health checks, and complex wiring. CYBERTEC's PG…

Why size Postgres for a peak you rarely reach?

Lakebase Postgres autoscaling monitors CPU, memory, and the database working set, then adjusts compute resources in real time to match actual workload. Because storage and compute…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates