PGNexus Daily News #257 2026-09-02
PGNexus Daily News PostgreSQL Technical Articles [image: Reading Table Bloat Before It Reads You] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fr...> NanoHertz Communications Reading Table Bloat Before It Reads You <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fr...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fr...> PostgreSQL Hackers Email Discussion Highlights LockHasWaiters() crashes on fast-path locks <https://pgnexus.ai/hacker-discussions?subject=LockHasWaiters()%20crashes%20o...> 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 <https://pgnexus.ai/hacker-discussions?subject=LockHasWaiters()%20crashes%20o...> PGQ catalog representation and pg_dump support <https://pgnexus.ai/hacker-discussions?subject=PGQ%20catalog%20representation...> 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 <https://pgnexus.ai/hacker-discussions?subject=PGQ%20catalog%20representation...> Bypassing cursors in postgres_fdw to enable parallel plans <https://pgnexus.ai/hacker-discussions?subject=Bypassing%20cursors%20in%20pos...> 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 <https://pgnexus.ai/hacker-discussions?subject=Bypassing%20cursors%20in%20pos...> Disallow outer-level and WHERE-clause aggregates in GRAPH_TABLE <https://pgnexus.ai/hacker-discussions?subject=Disallow%20outer-level%20and%2...> 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 <https://pgnexus.ai/hacker-discussions?subject=Disallow%20outer-level%20and%2...> Don't use the deprecated and insecure PQcancel in our frontend tools anymore <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> 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 <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> 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 <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-02-postgresql-daily-news-257.m...> Industry News [image: US Government Sides with OpenAI on LLM Copyright Training Issue] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com US Government Sides with OpenAI on LLM Copyright Training Issue <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> 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… [image: Uber Lays Off 10% of Global Workforce, Cutting 3,300 Jobs] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com Uber Lays Off 10% of Global Workforce, Cutting 3,300 Jobs <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> 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… [image: OpenAI Faces 30 New Lawsuits Tied to Tumbler Ridge Shooting] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com OpenAI Faces 30 New Lawsuits Tied to Tumbler Ridge Shooting <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> 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 [image: #VLDB2026 is underway, and Databricks is here as a Gold Sponsor.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin #VLDB2026 is underway, and Databricks is here as a Gold Sponsor. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… linkedin Day 0 access unlocked: Gemini 3.8 Flash is officially live on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… linkedin Databricks DevHub is the new home for developers looking to build working apps or agents faster. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more
participants (1)
-
pgnexus