PGNexus Daily News PostgreSQL Technical Articles [image: Data Lineage in PostgreSQL 19: Finally, an Answer When the CFO Asks "Where Did This Number Come From?"] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> Hans-Jürgen Schönig Data Lineage in PostgreSQL 19: Finally, an Answer When the CFO Asks "Where Did This Number Come From?" <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> PostgreSQL 19 introduces SQL/PGQ, a graph query extension that enables queryable data lineage directly within the database. By defining edge tables to record row-level transformat… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> [image: Highlights of Fujitsu's contribution in PostgreSQL 19] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Hayato Kuroda Highlights of Fujitsu's contribution in PostgreSQL 19 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Fujitsu's PostgreSQL team made notable contributions to PostgreSQL 19, with particular focus on improvements to logical replication. The post highlights the team's sustained code… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> PostgreSQL Hackers Email Discussion Highlights Fix race condition in pg_get_publication_tables with concurrent DROP TABLE <https://pgnexus.ai/hacker-discussions?subject=Fix%20race%20condition%20in%20...> A patch fixing a race condition in `pg_get_publication_tables` when a concurrent `DROP TABLE` occurs has been reviewed and pushed. Masahiko Sawada announced the intent to push the… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20race%20condition%20in%20...> [PATCH] SAOP nullability analysis below NOT/BooleanTest <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20SAOP%20nullabili...> Ayush Tiwari identified a potential bug in the `ScalarArrayOpExpr` handling within `find_nonnullable_rels()` and `find_nonnullable_vars()`: the `falseOK` argument added to `is_str… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20SAOP%20nullabili...> CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc. <https://pgnexus.ai/hacker-discussions?subject=CREATE%20SUBSCRIPTION%20...%20...> The discussion, led by Jeff Davis, addresses complexities in `CREATE SUBSCRIPTION ... SERVER` interactions with `pg_dump` and related operations. Key issues include: DDL-time vali… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=CREATE%20SUBSCRIPTION%20...%20...> Add pg_stat_kind_info system view <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20syst...> The thread discusses adding a `pg_stat_kind_info` system view to expose pgstats kind metadata. A key concern raised by Sami Imseih is that the `entry_size` field could mislead use… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20syst...> [Bug] pg_upgrade could fail for non-superuser subscriptions using foreign servers <https://pgnexus.ai/hacker-discussions?subject=%5BBug%5D%20pg_upgrade%20could...> A bug where `pg_upgrade` can fail for non-superuser subscriptions that depend on foreign servers is being addressed. Hayato Kuroda (Fujitsu) proposed introducing a new TOC entry i… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BBug%5D%20pg_upgrade%20could...> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> Tomas Vondra posted v8 of the Bloom filter pushdown patch series, focusing on improvements to build-side join relid generation. Key changes include patches 0013–0014, which incorp… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-28-postgresql-daily-news-221.m...> Social Media Updates linkedin Pavlo Golub is back with another conference vlog. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Pavlo Golub has released a new conference vlog covering PG DATA 2026 in Chicago. The video captures conference talks, hallway conversations, impressions of the city, and an early… linkedin We're heading to Black Hat USA 2026 for a week of conversations on the security challenges shaping today's SOC. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Databricks will attend Black Hat USA 2026 in Las Vegas, hosting product demos and conversations at booth #5106. On August 6, cyber expert Allie Mellen will join for a guest sessio… linkedin AI spend is climbing faster than the value it creates. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> AI spending is outpacing the value organizations actually receive. Databricks Co-founder and CTO Matei Zaharia and Product Director Kasey Uhlenhuth will present how Unity AI Gatew… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more