PGNexus Daily News

PostgreSQL Technical Articles

Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments

Santosh Mishra

Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments

Large index rebuilds on Amazon Aurora PostgreSQL can fail due to insufficient temporary storage, since PostgreSQL spills sort data to disk during REINDEX. This post describes comb…

Read the Blog
Introducing @neon/sdk, our new TypeScript client for the Neon API

Andre Landgraf

Introducing @neon/sdk, our new TypeScript client for the Neon API

Neon has released @neon/sdk, a TypeScript client library for the Neon API. While the existing Neon API is OpenAPI-compliant and supports programmatic management of database infras…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Row pattern recognition

Henson Choi posted a detailed review of the row pattern recognition (RPR) navigation offset consolidation patches (v51). While v51-0001 fixes the forward reach regression for FIRS…

Read Discussion
hashjoins vs. Bloom filters (yet again)

The discussion focuses on integrating Bloom filter (and more general runtime filter) pushdown into PostgreSQL's query planner. Matheus Alcantara posted a v5 PoC patch refining can…

Read Discussion
incremental backup issue

The thread discusses a bug in PostgreSQL 17.7's walsummarizer process on standbys, where it repeatedly logs "invalid record length ... got 0" every 10 seconds and never advances.…

Read Discussion
Grab bag of smaller OpenSSL fixups

Daniel Gustafsson submitted four small OpenSSL cleanup patches: removing a static variable that could interfere with future multithreading, replacing the deprecated `SSLv23_method…

Read Discussion
PSQL - prevent describe listing tables that are already in listed schemas

A patch to prevent psql's describe commands from listing tables that are already covered by listed schemas has been committed. Amit Kapila had previously reviewed and approved the…

Read Discussion
Vacuum statistics

Alena Rybakina posted a rebased v40 patch series adding vacuum statistics to PostgreSQL, organized so each commit introduces one category of stats. Bharath Rupireddy reviewed the…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

Apple's Trade Secrets Lawsuit Against OpenAI: The Wildest Allegations

techcrunch.com

Apple's Trade Secrets Lawsuit Against OpenAI: The Wildest Allegations

Apple's trade secrets lawsuit against OpenAI contains a series of striking allegations, including claims that employees joked about unauthorized access to Apple's systems and that…

Anthropic Launches Localized Claude Pricing for India

techcrunch.com

Anthropic Launches Localized Claude Pricing for India

Anthropic has begun localizing pricing for its Claude AI assistant in India, which is described as the company's biggest market outside the United States. Users in India are start…

Satya Nadella Issues Warning to Companies Over Reliance on Proprietary AI Models

techcrunch.com

Satya Nadella Issues Warning to Companies Over Reliance on Proprietary AI Models

Microsoft CEO Satya Nadella has issued a warning to companies using AI, addressing concerns that large AI labs selling proprietary models could be acting as "Trojan horses" for th…

Social Media Updates

linkedin

Enterprise security, compliance, and performance, built directly into PostgreSQL.

CYBERTEC PGEE enhances PostgreSQL with enterprise-grade capabilities built natively into the database, rather than added as external layers. Key features include Transparent Data…

linkedin

How do you diagnose whether a Postgres bottleneck is CPU, I/O, or network?

At POSETTE 2026, Rahila Syed demonstrated how to iteratively profile PostgreSQL performance using perf and pgbench, showing how bottlenecks shift as optimizations are applied. Usi…

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