PGNexus Daily News

PostgreSQL Technical Articles

What's New in Tiger Cloud: Bigger Performance Gains, Wider Platform Reach, Better Visibility

Nicole Ghalwash

What's New in Tiger Cloud: Bigger Performance Gains, Wider Platform Reach, Better Visibility

Tiger Cloud has shipped several updates to its managed PostgreSQL-based platform. TimescaleDB v2.26 and v2.27 deliver significant performance improvements: aggregate queries on co…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

index prefetching

Peter Geoghegan posted V31 of the index prefetching patch set, noting it addresses bit rot against the current master branch with only minor differences from the previous version.…

Read Discussion
walsummarizer can get stuck when switching timelines

The discussion concerns a bug where the WAL summarizer gets stuck during timeline switches. Thom Brown raised a clarifying question about whether the summarizer needs a CHECKPOINT…

Read Discussion
Fix GROUP BY ALL handling of ORDER BY operator semantics

A previously discussed revert of the "GROUP BY ALL handling of ORDER BY operator semantics" fix has been pushed by Tom Lane after no objections were raised during a waiting period…

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

The thread concerns a change to `visibilitymap_clear()` that converted a runtime `elog(ERROR)` check into an `Assert()`. Fujii Masao raised concern that in non-assert builds, a wr…

Read Discussion
doc: clarify wal_sender_shutdown_timeout behavior for small values

Chao Li submitted a documentation patch to clarify the behavior of `wal_sender_shutdown_timeout` for special values, noting that 0 causes immediate WAL sender termination via `Wal…

Read Discussion
Restructured Shared Buffer Hash Table

Dhruv Aron (Databricks) proposes replacing PostgreSQL's dynahash-based shared buffer lookup table with a specialized hash table offering simpler structure, lower memory overhead,…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

Amazon fixing bug that billed some AWS customers billions of dollars

techcrunch.com

Amazon fixing bug that billed some AWS customers billions of dollars

Amazon is working to fix a billing bug that caused some AWS customers to see wildly inflated charges — in some cases showing estimated bills in the billions of dollars. The errone…

Nuclear startup Valar Atomics in talks to raise new funding at $6B valuation

techcrunch.com

Nuclear startup Valar Atomics in talks to raise new funding at $6B valuation

Nuclear energy startup Valar Atomics is reportedly in talks to raise a new funding round at a $6 billion valuation. The potential deal is notable not only for its scale but also b…

Social Media Updates

The pgEdge AI Knowledgebase Builder now ships per-model database packages instead of a single monolithic DB.

linkedin

The pgEdge AI Knowledgebase Builder now ships per-model database packages instead of a single monolithic DB.

pgEdge AI Knowledgebase Builder has replaced its single monolithic SQLite database with separate per-model packages. Previously, pre-computed embeddings for all supported models w…

In PostgreSQL, every write starts in the WAL before it's flushed to disk.

linkedin

In PostgreSQL, every write starts in the WAL before it's flushed to disk.

In PostgreSQL, all writes go through the WAL before being flushed to disk, with CHECKPOINT forcing that flush to bring the database to a consistent state. Prior to PostgreSQL 19,…

linkedin

Backups belong to everyone.

pg_hardstorage is an open-source backup solution for PostgreSQL, released under the Apache 2.0 license. The project is fully open source, both in its licensing and in how it is bu…

Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus to learn more