PGNexus Daily News #214 2026-07-21
PGNexus Daily News PostgreSQL Technical Articles [image: Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> Caio Maia Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> Nubank migrated its NuPay payment platform—managing 7.5 TB and over 31 billion rows—from self-managed PostgreSQL to Amazon Aurora PostgreSQL. The primary drivers were severe query… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> [image: PostgreSQL vs Destructive Time Travel: The Year 2038 Problem] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> Abhisek Goswami PostgreSQL vs Destructive Time Travel: The Year 2038 Problem <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> PostgreSQL stores timestamps as 64-bit integers representing microseconds since 2000-01-01, giving it a range extending to approximately year 294276. This design sidesteps the Yea… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> PostgreSQL Hackers Email Discussion Highlights [PATCH] Fix memory leak in pg_config <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20memory%20l...> Ivan Kush reported a memory leak in pg_config discovered via LeakSanitizer: get_configdata() allocates a ConfigData array and strings using palloc_array()/pstrdup(), but pg_config… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20memory%20l...> [PATCH v1] Add vacuum_delay_point() to GiST empty-page deletion pass <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%20v1%5D%20Add%20vacuu...> Paul Kim noticed that `gistvacuum_delete_empty_pages()`, the second pass of GiST vacuum that unlinks empty leaf pages, never calls `vacuum_delay_point()`, unlike the other scannin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%20v1%5D%20Add%20vacuu...> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> Tomas Vondra profiled a simple star-join schema with Bloom filter pushdown enabled, finding planning time jumped from 30ms to ~500ms. Two main issues were identified: (1) `expecte… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> Patch for migration of the pg_commit_ts directory <https://pgnexus.ai/hacker-discussions?subject=Patch%20for%20migration%20of%2...> The discussion concerns a patch for migrating the `pg_commit_ts` directory during PostgreSQL major version upgrades (pg_upgrade). The author (ls7777) explains that the patch check… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Patch%20for%20migration%20of%2...> amcheck: add index-all-keys-match verification for B-Tree <https://pgnexus.ai/hacker-discussions?subject=amcheck%3A%20add%20index-all-k...> Andrey Borodin posted v6 of a patchset adding index-all-keys-match verification to amcheck for B-Tree indexes. The four-patch series covers: (0001) core indexallkeysmatch verifica… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=amcheck%3A%20add%20index-all-k...> RFC: Logging plan of the running query <https://pgnexus.ai/hacker-discussions?subject=RFC%3A%20Logging%20plan%20of%2...> The thread discusses the `pg_log_query_plan()` feature for logging execution plans of running queries. Key points include: whether to add a `pg_stat_activity` column for pending l… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=RFC%3A%20Logging%20plan%20of%2...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-21-postgresql-daily-news-214.m...> Industry News [image: AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> AI music generation platform Suno has suffered a major data breach affecting approximately 55 million users, according to breach-tracking service Have I Been Pwned. A hacker obtai… [image: OpenAI Claims Responsibility for Hugging Face Security Breach] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com OpenAI Claims Responsibility for Hugging Face Security Breach <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> OpenAI has publicly acknowledged responsibility for a security breach at AI platform Hugging Face, stating the incident was caused by internal pre-release model testing that went… [image: Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Google has launched three new Gemini AI models — Gemini 3.6 Flash, 3.5 Flash-Lite, and Flash Cyber — but conspicuously omitted a long-anticipated Gemini 3.5 Pro release. The conti… Social Media Updates linkedin One global team, one mission: PostgreSQL. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> The content highlights a global team united around a single mission focused on PostgreSQL. It references an external link, suggesting further details are available there, but no a… [image: Google 's Gemini 3.6 Flash is now available on Databricks!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Google 's Gemini 3.6 Flash is now available on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Google's Gemini 3.6 Flash is now available on Databricks. Internal evaluations show it outperforms Gemini 3.5 Flash in document classification, with particular strength on long-fo… linkedin The Department for Environment, Food and Rural Affairs and Natural England are using the Databricks Data + AI Platform and AI to accelerate peatland mapping across England 🗺️ An area the size of the West Pennines that once took about a week to map manually can now be processed in less than a day. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> The UK Department for Environment, Food and Rural Affairs and Natural England are using the Databricks Data and AI Platform to accelerate peatland mapping across England. An area… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more
participants (1)
-
pgnexus