PGNexus Daily News PostgreSQL Technical Articles [image: Knowing When Your Composite Index Earns Its Write Cost] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fk...> NanoHertz Communications Knowing When Your Composite Index Earns Its Write Cost <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fk...> Composite indexes in PostgreSQL reduce read cost but impose a write penalty on every insert. This guide presents a four-step framework: verify the index serves queries via its lea… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fk...> PostgreSQL Hackers Email Discussion Highlights RFC: Logging plan of the running query <https://pgnexus.ai/hacker-discussions?subject=RFC%3A%20Logging%20plan%20of%2...> The discussion concerns a proposed `pg_log_query_plan()` function for logging the execution plan of a currently running query. Torikoshia suggested that when called, the function… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=RFC%3A%20Logging%20plan%20of%2...> Implement missing join selectivity estimation for range types <https://pgnexus.ai/hacker-discussions?subject=Implement%20missing%20join%20s...> Bryan Green identified a security vulnerability in the patch implementing join selectivity estimation for range types. Specifically, `rangejoinsel` and `multirangejoinsel` in patc… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Implement%20missing%20join%20s...> eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%20...> Melanie Plageman continues refining patches related to eliminating xl_heap_visible to reduce WAL. Four new patches are described: 0001 adds an assert to prevent silent VM pin leak… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%20...> Reject WAIT FOR earlier in transaction-snapshot mode <https://pgnexus.ai/hacker-discussions?subject=Reject%20WAIT%20FOR%20earlier%...> The discussion covers final documentation wording refinements for a patch that rejects `WAIT FOR` earlier in transaction-snapshot mode. Alexander Korotkov and Sami Imseih iterated… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Reject%20WAIT%20FOR%20earlier%...> remove_useless_joins vs. bug #19560 <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20b...> Haibo Yan reports a regression introduced by commit e28cf96e935 ("Fix stale copies of PHVs in subqueries"). The bug allows an upper-level PlaceHolderVar (PHV) containing an unproc… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20b...> [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> The patch addresses releasing replication slots on error in SQL-callable slot functions. Kedar Anavardekar suggested renaming `MyReplicationSlotSubId` to `MyReplicationSlotSubXact… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-18-postgresql-daily-news-273.m...> Industry News [image: Researchers used Anthropic's Claude to hack into OpenAI] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com Researchers used Anthropic's Claude to hack into OpenAI <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> Security researchers exploited vulnerabilities in OpenAI's systems using Anthropic's Claude AI model. The attackers were able to take over employee accounts and gain unauthorized… [image: A new kind of AI model from a ChatGPT inventor is thrilling developers] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com A new kind of AI model from a ChatGPT inventor is thrilling developers <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> Jev, a new AI model created by one of ChatGPT's inventors, is generating significant excitement among developers. The model is reported to offer a cheaper and faster path to softw… [image: Google's new 'CC' is an AI agent that helps families run their households] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> techcrunch.com Google's new 'CC' is an AI agent that helps families run their households <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2F...> Google has refocused its CC AI agent on household coordination, targeting families as its primary users. The agent allows family members to share emails, schedules, and tasks, ena… Social Media Updates [image: We recently onboarded Zoltan Rosta to CYBERTEC.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin We recently onboarded Zoltan Rosta to CYBERTEC. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> CYBERTEC has welcomed Zoltan Rosta as a new Project Manager, where he will take full responsibility for the company's training programs. His addition is expected to strengthen the… linkedin "I think that right now, the existential risk is close to zero." <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Databricks CEO and co-founder Ali Ghodsi spoke with Andreessen Horowitz General Partners Martin Casado and Sarah Wang about AI risk, enterprise adoption barriers, and where compan… [image: Modernizing recurring SQL ETL doesn't require rewriting the workflows you already rely on.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Modernizing recurring SQL ETL doesn't require rewriting the workflows you already rely on. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Declarative ETL is being introduced directly into Databricks Lakehouse, allowing SQL practitioners to modernize recurring data pipelines without abandoning familiar SQL workflows.… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more