PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights remove_useless_joins vs. bug #19560 <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20b...> Tom Lane proposed reworking `analyzejoins.c` to perform join removals directly on the jointree representation rather than relying on planner-derived data, looping back to redo `de… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20b...> NULL pointer dereference in syslogger with load_libraries() and -DEXEC_BACKEND at startup <https://pgnexus.ai/hacker-discussions?subject=NULL%20pointer%20dereference%2...> The discussion focuses on a missing PGDLLIMPORT marking on the `syslogger_setup_done` variable in `src/include/postmaster/syslogger.h`. Anton Voloshin noted that since commit 8ec5… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=NULL%20pointer%20dereference%2...> [PATCH] Batched clock sweep to reduce cross-socket atomic contention <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Batched%20clock%...> Greg Burd acknowledges corrections from Ants Aasma and Andres Freund regarding his patch series on batched clock sweep and buffer eviction. He had incorrectly described BAS_BULKWR… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Batched%20clock%...> Social Media Updates [image: Here is a question most CISOs don't ask their compliance vendor until it is too late: If we part ways tomorrow, can we still read our own audit data?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Here is a question most CISOs don't ask their compliance vendor until it is too late: If we part ways tomorrow, can we still read our own audit data? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Many CISOs fail to ask a critical question before committing to a compliance vendor: whether they can still access their own audit data after ending the relationship. Scalefield S… linkedin What does it take to move AI agents from prototype to production? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Databricks' Amber R. and Craig Wiley walk through the full lifecycle of AI agents, covering how to build, evaluate, deploy, and scale them for production use. The session highligh… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more