PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Key joins <https://pgnexus.ai/hacker-discussions?subject=Key%20joins> Joel Jacobson reviewed Arne Roland's revised patch series for the "Key joins" feature, which breaks the implementation into ten smaller, more focused commits. The series covers: p… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Key%20joins> allow spread checkpoints when changing checksums online <https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%2...> The discussion centers on a patch (v4) by Tomas Vondra that allows spread checkpoints when enabling or disabling data checksums online. Ewan Young caught a documentation bug where… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%2...> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan has prepared V30 of the index prefetching patch series, targeting a push of patch 0001 within 7–10 days. Tomas Vondra reviewed 0001 and raised several points: a mi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server <https://pgnexus.ai/hacker-discussions?subject=Bug%20in%20ALTER%20SUBSCRIPTIO...> The discussion concerns a bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION when the old server is unreachable. Amit Kapila suggested using the (connect = false) option to ind… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Bug%20in%20ALTER%20SUBSCRIPTIO...> support create index on virtual generated column. <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on%...> The patch (V5) to support creating indexes on virtual generated columns received regression test failures reported by CFBot. ZizhuanLiu reverted earlier modifications to `btcostes… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on%...> relfilenode statistics <https://pgnexus.ai/hacker-discussions?subject=relfilenode%20statistics> Michael Paquier is working on a redesign of relfilenode statistics, focusing on cleaning up relation stats data for indexes, where many fields stored in memory and written to disk… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=relfilenode%20statistics> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-11-postgresql-daily-news-204.m...> Social Media Updates linkedin As AI teams adopt more autonomous agents, one challenge becomes clear: they don't naturally work together. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> As AI teams deploy more autonomous agents, a core challenge emerges: these agents do not naturally collaborate. Omnigent is an open-source meta-harness that operates above individ… [image: CEO CYBERTEC Hans-Juergen Schoenig 's new blog walks through the full journey...] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin CEO CYBERTEC Hans-Juergen Schoenig 's new blog walks through the full journey... <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> CYBERTEC CEO Hans-Juergen Schoenig published a new blog post tracing the complete data path in PostgreSQL, from storage through the pg_hardstorage repository and back during recov… [image: CYBERTEC is hiring a Lead Infrastructure Support Engineer in India.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin CYBERTEC is hiring a Lead Infrastructure Support Engineer in India. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> CYBERTEC is seeking a Lead Infrastructure Support Engineer based in India. The role involves leading a team responsible for maintaining enterprise PostgreSQL infrastructure, with… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more