PostgreSQL Technical Articles

NanoHertz Communications

Table bloat in PostgreSQL can affect append-only tables despite no UPDATE or DELETE operations. Aborted batch inserts leave dead tuples, while PostgreSQL 13+ autovacuum fires on i…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

LockHasWaiters() crashes on fast-path locks

The discussion concerns a bug where `LockHasWaiters()` crashes when called on fast-path locks. Robert Haas argued that having `LockHasWaiters()` add entries to the main lock table…

Read Discussion

PGQ catalog representation and pg_dump support

The Release Management Team (RMT), represented by Melanie Plageman, has raised serious concerns about the readiness of PGQ (Property Graph Queries) for PostgreSQL 19. Multiple unr…

Read Discussion

Bypassing cursors in postgres_fdw to enable parallel plans

The discussion concerns a patch to bypass cursors in postgres_fdw, enabling parallel query plans. Robert Haas identified several correctness issues: canceling queries in postgresR…

Read Discussion

Disallow outer-level and WHERE-clause aggregates in GRAPH_TABLE

The discussion concerns design issues with `GraphPropertyRef` in the `GRAPH_TABLE` implementation (PGQ). Tom Lane dislikes `GraphPropertyRef` as a distinct node type because it mu…

Read Discussion

Don't use the deprecated and insecure PQcancel in our frontend tools anymore

Jelte Fennema-Nio has rebased a patch series aimed at replacing the deprecated and insecure PQcancel API in PostgreSQL frontend tools. Among the approaches previously discussed by…

Read Discussion

hashjoins vs. Bloom filters (yet again)

Andrei Lepikhov responds to Tomas Vondra's discussion on integrating Bloom filters into PostgreSQL's query optimizer. He argues the bottom-up, cost-based approach faces two fundam…

Read Discussion

Industry News

techcrunch.com

US Government Sides with OpenAI on LLM Copyright Training Issue

The United States government has filed a brief supporting OpenAI's position that training large language models on copyrighted material is permissible. The brief argues that "The…

techcrunch.com

Uber Lays Off 10% of Global Workforce, Cutting 3,300 Jobs

Uber is laying off approximately 3,300 employees, representing about 10% of its global headcount. The company says the cuts are aimed at reducing management layers and redirecting…

techcrunch.com

OpenAI Faces 30 New Lawsuits Tied to Tumbler Ridge Shooting

Law firm Edelson PC is filing 30 new lawsuits against OpenAI in connection with the Tumbler Ridge shooting. The suits escalate previous claims, now including allegations of aiding…

Social Media Updates

#VLDB2026 is underway, and Databricks is here as a Gold Sponsor.

Databricks is participating in VLDB 2026 as a Gold Sponsor, showcasing its work on agent-native data infrastructure. Highlights include a keynote by co-founder Reynold Xin on Lake…

Day 0 access unlocked: Gemini 3.8 Flash is officially live on Databricks!

Google's Gemini 2.5 Flash model is now available on Databricks from day one of its release. The model delivers strong performance in internal document parsing and leads the Office…

Databricks DevHub is the new home for developers looking to build working apps or agents faster.

Databricks has launched DevHub, a centralized resource for developers who want to build applications or AI agents more quickly. The platform offers ready-to-use templates and step…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates