PostgreSQL Technical Articles

Carlota Soto

Lakebase Postgres, offered by Neon, eliminates the need to pre-select a database instance size by incorporating autoscaling. Traditional database provisioning requires workload es…

Read the Blog

Fujitsu

Database migration tools: An enterprise buyer's guide

Enterprise database migration tools often appear comparable in feature matrices, but real differences surface under production conditions: stored procedures that resist automated…

Read the Blog

Tristan Vermeesch

How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud

Companion.energy migrated real-time energy sensor telemetry from Azure PostgreSQL with a limited Apache 2 TimescaleDB extension to Tiger Cloud's fully featured managed TimescaleDB…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

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

The discussion centers on a patch to release replication slots on error in SQL-callable slot functions, particularly fixing a crash and slot leak when slot creation fails inside a…

Read Discussion

another autovacuum scheduling thread

Nathan Bossart identified a corner case in the autovacuum scheduling feature, discovered with help from Claude. The issue is that when freeze score weights are sufficiently high,…

Read Discussion

REPACK (ANALYZE) within transaction block segfaults

Osama Abdul Qader posted an update to the "REPACK (ANALYZE) within transaction block segfaults" thread, but it was actually intended for a different discussion about replication s…

Read Discussion

Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master

Zsolt Parragi reported a regression introduced by commit 90eae926abbb, which broke routed ON CONFLICT inserts on partitioned tables when a leaf partition has a deferrable unique c…

Read Discussion

Reducing relcache memory usage: deduping index shapes

Matthias van de Meent proposes a patchset to reduce relcache memory usage by deduplicating shared index data fields (rd_opfamily, rd_opcintype, rd_support, rd_supportinfo) across…

Read Discussion

REPACK (CONCURRENTLY) fails with wrong error for materialized views

The discussion addresses a bug where `REPACK (CONCURRENTLY)` produces a misleading "has no identity index" error when applied to a materialized view. Bharath Rupireddy submitted a…

Read Discussion

Industry News

techcrunch.com

Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips

Nvidia has invested $3.5 billion into Taiwanese chipmaker MediaTek, signaling a strategic move to stay central to AI infrastructure as major tech companies increasingly develop th…

techcrunch.com

Microsoft Tests Fix After Hours-Long Outlook Outage

Microsoft is testing a fix for a widespread Outlook outage that caused hours of email delays and delivery failures. The incident affected a significant number of users and drew at…

Social Media Updates

pg_hardstorage is an open-source PostgreSQL backup tool, developed by our team at CYBERTEC.

pg_hardstorage is an open-source PostgreSQL backup tool developed by the team at CYBERTEC. A brief walkthrough of the tool is available, and the source code is publicly accessible…

Genie is a game changer.

Users describe Genie as a transformative tool that accelerates their workflow from ideation to production with fewer errors. According to firsthand accounts, Genie helps users ask…

Databricks has been named to Madrona 's 2026 Intelligent Applications 40 list!

Databricks has been named to Madrona's 2026 Intelligent Applications 40 list, which recognizes top private companies building and enabling AI applications. Notably, Databricks is…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates