PGNexus Daily News #255 2026-08-31
PGNexus Daily News PostgreSQL Technical Articles [image: Autoscaling Lakebase Postgres] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fautoscalin...> Carlota Soto Autoscaling Lakebase Postgres <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fautoscalin...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fautoscalin...> [image: Database migration tools: An enterprise buyer's guide] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Fujitsu Database migration tools: An enterprise buyer's guide <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> [image: How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> Tristan Vermeesch How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> PostgreSQL Hackers Email Discussion Highlights [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> 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 <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> another autovacuum scheduling thread <https://pgnexus.ai/hacker-discussions?subject=another%20autovacuum%20schedul...> 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 <https://pgnexus.ai/hacker-discussions?subject=another%20autovacuum%20schedul...> REPACK (ANALYZE) within transaction block segfaults <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%20...> 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 <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%20...> Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master <https://pgnexus.ai/hacker-discussions?subject=Routed%20ON%20CONFLICT%20inser...> 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 <https://pgnexus.ai/hacker-discussions?subject=Routed%20ON%20CONFLICT%20inser...> Reducing relcache memory usage: deduping index shapes <https://pgnexus.ai/hacker-discussions?subject=Reducing%20relcache%20memory%2...> 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 <https://pgnexus.ai/hacker-discussions?subject=Reducing%20relcache%20memory%2...> REPACK (CONCURRENTLY) fails with wrong error for materialized views <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fail...> 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 <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fail...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-31-postgresql-daily-news-255.m...> Industry News [image: Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> 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… [image: Microsoft Tests Fix After Hours-Long Outlook Outage] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Microsoft Tests Fix After Hours-Long Outlook Outage <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> 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 linkedin pg_hardstorage is an open-source PostgreSQL backup tool, developed by our team at CYBERTEC. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… linkedin Genie is a game changer. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… [image: Databricks has been named to Madrona 's 2026 Intelligent Applications 40 list!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Databricks has been named to Madrona 's 2026 Intelligent Applications 40 list! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more
participants (1)
-
pgnexus