PostgreSQL Technical Articles

Caio Maia

Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL

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

Abhisek Goswami

PostgreSQL vs Destructive Time Travel: The Year 2038 Problem

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

PostgreSQL Hackers Email Discussion Highlights

[PATCH] Fix memory leak in pg_config

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

[PATCH v1] Add vacuum_delay_point() to GiST empty-page deletion pass

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

hashjoins vs. Bloom filters (yet again)

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

Patch for migration of the pg_commit_ts directory

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

amcheck: add index-all-keys-match verification for B-Tree

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

RFC: Logging plan of the running query

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

Industry News

techcrunch.com

AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users

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…

techcrunch.com

OpenAI Claims Responsibility for Hugging Face Security Breach

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…

techcrunch.com

Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro

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

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates