PGNexus Daily News PostgreSQL Technical Articles [image: PGConf India 2027 - Dates Announced and CFP Open] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> www.postgresql.org PGConf India 2027 - Dates Announced and CFP Open <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> PGConf India 2027 is scheduled for March 2–5, 2027, at the Sheraton Grand Hotel at Brigade Gateway, Bengaluru. The Call for Papers is now open, with submissions closing October 15… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> PostgreSQL Hackers Email Discussion Highlights pgstat: Flush some statistics within running transactions, take 2 <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20sta...> Sami Imseih posted a rebase of the patch series for flushing PostgreSQL statistics within running transactions. The discussion references Michael's earlier refactoring work on pat… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20sta...> SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator <https://pgnexus.ai/hacker-discussions?subject=SUM(int2)%2FSUM(int4)%20do%20n...> The discussion concerns a patch to detect integer overflow in the int8 accumulator used by SUM(int2) and SUM(int4). David Rowley proposed using PG_RETURN_INPUT(n) to reduce instru… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SUM(int2)%2FSUM(int4)%20do%20n...> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> Rui Zhao reports that patch v10 applies cleanly to current master, passes all 248 regression tests, and produces correct results across 480 query/GUC combinations. He identifies a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> tablecmds: fix bug where index rebuild loses replica identity on partitions <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20whe...> A bug is reported where renaming a partition's index to a name that conflicts with an auto-generated name causes an error during `ALTER TABLE ... ALTER COLUMN ... TYPE`. The issue… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20whe...> Add wait events for server logging destination writes <https://pgnexus.ai/hacker-discussions?subject=Add%20wait%20events%20for%20se...> The discussion covers a patch (v7) adding wait events for server logging destination writes (syslog, stderr, Windows console/eventlog). Seongjun Shin responds to Jakub Wartak's an… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20wait%20events%20for%20se...> Collect ALTER PUBLICATION commands for event triggers <https://pgnexus.ai/hacker-discussions?subject=Collect%20ALTER%20PUBLICATION%...> Shihao Zhong reviewed the v2 patch set for collecting ALTER PUBLICATION commands for event triggers. He tested v2 on master with asserts and noted that patch 0003 should be commit… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Collect%20ALTER%20PUBLICATION%...> Social Media Updates linkedin Team CYBERTEC will be at PgDay Lowlands coming Thursday! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> CYBERTEC will have two representatives at PgDay Lowlands in Utrecht this Thursday: Peter Hofer, Chief Product Officer, and Christoph Berg, Senior PostgreSQL Engineer. Attendees ar… [image: Better AI agents need better context.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Better AI agents need better context. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Databricks has launched the Certified Context Engineer Associate certification, designed to validate skills in curating context and building reliable, production-grade agentic AI… [image: On Tuesday 8th Sept, I'll be speaking at PGDay UK about rebuilding a major piece of PostgreSQL backup infrastructure from scratch!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin On Tuesday 8th Sept, I'll be speaking at PGDay UK about rebuilding a major piece of PostgreSQL backup infrastructure from scratch! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> The author will be speaking at PGDay UK in London on Tuesday, 8th September, covering the topic of rebuilding a major PostgreSQL backup infrastructure from scratch. The talk relat… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more