August 2026 - Pgtechdailyen - lists.ivorysql.org

PGNexus Daily News #245 2026-08-21
by pgnexus Aug. 21, 2026

Aug. 21, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: PostgreSQL migration for enterprise environments: What to plan for] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu PostgreSQL migration for enterprise environments: What to plan for <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Enterprise PostgreSQL migrations succeed or fail based on planning done well before cutover. The article emphasizes that most teams underestimate the planning phase, rushing towar… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: How to Tell Whether Your Slow Query Is a Planning or an Execution Problem] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> NanoHertz Communications How to Tell Whether Your Slow Query Is a Planning or an Execution Problem <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL's EXPLAIN ANALYZE output includes both Planning Time and Execution Time, but engineers often ignore the former. On a table partitioned into 500 daily chunks, planning a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights split tablecmds.c <https://pgnexus.ai/hacker-discussions?subject=split%20tablecmds.c> The thread discusses a patch to split `tablecmds.c` by moving partitioning-related code into a new `tablecmds_partition.c` file and introducing `tablecmds_internal.h` for shared d… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=split%20tablecmds.c> [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> The discussion concerns a patch (v13) to release replication slots on error in SQL-callable slot functions. Masahiko Sawada reviewed v12 and proposed several comment/naming improv… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> The thread discusses v10 of a patch series adding Bloom filter pushdown to hash joins. Matheus Alcantara addressed several issues from Rui Zhao's review: correcting probe cost cha… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> problems with toast.* reloptions <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20r…> Nathan Bossart has committed most of the patch series addressing problems with toast.* reloptions, leaving only the last two patches pending. He attached a rebased patch set incor… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20r…> missing possibility to use alternative translated month names in to_char function <https://pgnexus.ai/hacker-discussions?subject=missing%20possibility%20to%20…> The thread discusses a patch by Pavel Stehule adding a `TAMMONTH`/`TAMMON` modifier to PostgreSQL's `to_char()` function. The motivation is that glibc 2.28+ returns month names in… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=missing%20possibility%20to%20…> Introduce XID age based replication slot invalidation <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based…> The thread discusses introducing XID-age-based replication slot invalidation, specifically focusing on how synced slots on standbys should be handled. Bharath Rupireddy and Bertra… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-21-postgresql-daily-news-245.…> Social Media Updates [image: NBCUniversal modernized its data infrastructure to support the speed and scale of a modern media business, where major content launches, awards shows, and live events can drive sudden spikes in analytics demand.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin NBCUniversal modernized its data infrastructure to support the speed and scale of a modern media business, where major content launches, awards shows, and live events can drive sudden spikes in analytics demand. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> NBCUniversal partnered with Databricks and EXL to modernize its data infrastructure, consolidating data engineering, analytics, and machine learning onto a unified platform. The m… linkedin As agentic automation helps developers get more done, the role is evolving toward higher-level decisions about what to build, how systems should work, and where taste and creativity matter most. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Agentic automation is shifting the developer role away from routine coding toward higher-level decisions about system design, product direction, and creative judgment. Databricks… [image: UUID v4 has been quietly wrecking B-tree indexes for decades - most shops just chalk it up to Postgres being Postgres.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin UUID v4 has been quietly wrecking B-tree indexes for decades - most shops just chalk it up to Postgres being Postgres. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> UUID v4 generates random values that land on arbitrary B-tree leaf pages, causing cache misses, page splits, and high fragmentation. In testing with one million rows, v4 produces… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #244 2026-08-20
by pgnexus Aug. 20, 2026

Aug. 20, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Migrate multilingual full-text search from SQL Server to PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Ken Zhang Migrate multilingual full-text search from SQL Server to PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> This AWS blog post by Ken Zhang addresses subtle result discrepancies when migrating multilingual full-text search (FTS) from SQL Server to Aurora PostgreSQL or Amazon RDS for Pos… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Open-weight models are fast on Neon AI Gateway. Here's why] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fopen-weig…> Carlota Soto Open-weight models are fast on Neon AI Gateway. Here's why <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fopen-weig…> Open-weight AI models can be fast in theory, but actual end-user performance depends heavily on the serving infrastructure. Neon AI Gateway routes requests to Databricks Foundatio… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fopen-weig…> [image: 180x Faster Recovery: How EDB Postgres® AI Rewrote RPO/RTO Math with WarehousePG Disaster Recovery] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2F1…> enterprisedb.com 180x Faster Recovery: How EDB Postgres® AI Rewrote RPO/RTO Math with WarehousePG Disaster Recovery <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2F1…> A banking customer using logical backups faced critical issues: full backups took nearly two days, ran almost continuously, and restoring to a disaster recovery cluster required e… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2F1…> PostgreSQL Hackers Email Discussion Highlights walsummarizer can get stuck when switching timelines <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> The discussion addresses a flaky test related to the `walsummarizer` getting stuck when switching timelines. Alexander Lakhin identified that the test failure was caused by the bg… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> Fix CPU cost of right-semi and right-anti hash joins <https://pgnexus.ai/hacker-discussions?subject=Fix%20CPU%20cost%20of%20right…> The thread discusses fixing the CPU cost estimation for RIGHT_SEMI and RIGHT_ANTI hash joins in PostgreSQL's planner. The original bug: `hashjointuples` was computed using `path->… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20CPU%20cost%20of%20right…> Allow a prosupport function to be attached to an aggregate <https://pgnexus.ai/hacker-discussions?subject=Allow%20a%20prosupport%20func…> The thread discusses adding support for attaching a `prosupport` function to an aggregate in PostgreSQL. Andrei Lepikhov assembled a two-patch series: one documenting `SupportRequ… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Allow%20a%20prosupport%20func…> Crash issue in PG18.5 regression <https://pgnexus.ai/hacker-discussions?subject=Crash%20issue%20in%20PG18.5%2…> Jeff Davis committed a fix for a bug in PostgreSQL 18 related to a crash issue found in regression testing. The bug, identified by Andres Freund as a real defect despite no known… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Crash%20issue%20in%20PG18.5%2…> Logical replication row filter loses unchanged toasted columns <https://pgnexus.ai/hacker-discussions?subject=Logical%20replication%20row%2…> The discussion addresses a bug where logical replication row filters silently lose data when a UPDATE changes the replica identity key but leaves a TOASTed non-identity column unc… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Logical%20replication%20row%2…> aio: Don't silently drop wait_event_info <https://pgnexus.ai/hacker-discussions?subject=aio%3A%20Don't%20silently%20drop%20wait_event_info> The discussion addresses a bug where `wait_event_info` passed by callers is silently dropped in PostgreSQL's AIO subsystem. Nazir Bilal Yavuz proposed storing `wait_event_info` in… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=aio%3A%20Don't%20silently%20drop%20wait_event_info> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-20-postgresql-daily-news-244.…> Industry News [image: Grok Experiences Widespread Gibberish Response Failures for Users] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Grok Experiences Widespread Gibberish Response Failures for Users <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> xAI's Grok AI assistant began sending incoherent, gibberish responses to users, with affected users reporting they were using Grok Lite when the issues emerged. The problems were… [image: Meta Launches Pocket App in the US, Enabling AI-Powered Game Creation and Sharing] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Meta Launches Pocket App in the US, Enabling AI-Powered Game Creation and Sharing <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Meta is expanding its experimental AI-powered app Pocket to users across the United States, after an initial quiet test run in Brazil. Pocket allows users to create and share inte… techcrunch.com Study Finds a Third of Web Pages Published Since ChatGPT's Launch Show AI Authorship Signs <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> A new study has found that approximately one-third of web pages published since the launch of ChatGPT show signs of AI authorship, indicating that AI models such as ChatGPT are no… Social Media Updates [image: Discover how CYPEX can support your organization's PostgreSQL modernization journey.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Discover how CYPEX can support your organization's PostgreSQL modernization journey. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYPEX offers a PostgreSQL Application Platform built for organizations looking to modernize legacy applications, streamline business workflows, or develop new enterprise applicati… linkedin Your AI is smart enough. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks is hosting an event on September 23 focused on Genie Ontology, a solution designed to give AI systems deeper business context. Attendees will learn how to build a conte… linkedin What does it take to run data behind products used by one billion people every week? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> OpenAI uses Databricks as its governed, multicloud data foundation spanning Azure and AWS. The platform supports analytics, marketing, finance, trust and safety, and security oper… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #243 2026-08-19
by pgnexus Aug. 19, 2026

Aug. 19, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Loongson loong64 packages on apt.postgresql.org] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org Loongson loong64 packages on apt.postgresql.org <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL packages for the Loongson loong64 architecture are now available on apt.postgresql.org. This Chinese processor architecture is supported via a build host running on a L… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights Checkpointer write combining <https://pgnexus.ai/hacker-discussions?subject=Checkpointer%20write%20combin…> Melanie Plageman posted v16 of the checkpointer write-combining patch series, responding to reviews from Andrey Borodin and Haibo Yan. Key changes include dropping the ring-sweep… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Checkpointer%20write%20combin…> Support EXCEPT for TABLES IN SCHEMA publications <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABL…> The discussion centers on a patch adding EXCEPT clause support for TABLES IN SCHEMA in PostgreSQL publications. Key debate involves whether conflicting specifications—such as excl… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABL…> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> The thread centers on Tomas Vondra's survey of how other databases (DuckDB, ClickHouse, Spark, Trino, Impala, Hive) implement runtime/dynamic/join filters, finding three common fi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> One more bit of PL/Perl cleanup <https://pgnexus.ai/hacker-discussions?subject=One%20more%20bit%20of%20PL%2F…> Tom Lane identified redundant checks in PL/Perl code where `SvOK(sv) && SvROK(sv)` is tested together. Examining Perl's `sv.h`, he confirmed that `SVf_ROK` is a subset of the flag… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=One%20more%20bit%20of%20PL%2F…> Report index currently being vacuumed in pg_stat_progress_vacuum <https://pgnexus.ai/hacker-discussions?subject=Report%20index%20currently%20…> The discussion concerns how to expose parallel vacuum worker information in `pg_stat_progress_vacuum`. Bharath Rupireddy had proposed position-aligned arrays for index OIDs and wo… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Report%20index%20currently%20…> Residual cleanups for tied objects in PL/Perl <https://pgnexus.ai/hacker-discussions?subject=Residual%20cleanups%20for%20t…> A patch addressing residual cleanups for tied objects in PL/Perl has been committed. Tom Lane pushed the changes after making mostly cosmetic adjustments and incorporated test cas… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Residual%20cleanups%20for%20t…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-19-postgresql-daily-news-243.…> Industry News [image: Google packs Search and Gemini with new AI study tools for students] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Google packs Search and Gemini with new AI study tools for students <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Google has launched new AI-powered study tools integrated into both Search and Gemini, targeting students as a key user segment. The move is part of Google's broader strategy to p… [image: Rillet raises $100M Series C at $1B valuation, becoming an AI accounting unicorn] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Rillet raises $100M Series C at $1B valuation, becoming an AI accounting unicorn <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> AI-native accounting startup Rillet has raised a $100 million Series C funding round at a $1 billion valuation, achieving unicorn status just two years after emerging from stealth… Social Media Updates [image: 👋 Meet Arvid Quarshie - Our New Delivery Manager!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin 👋 Meet Arvid Quarshie - Our New Delivery Manager! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC has welcomed Arvid Quarshie as its new Delivery Manager, joining the Sales team. In this role, he will be responsible for ensuring client projects are delivered on time a… linkedin For decades, transaction processing and analytics have lived in separate systems that need to stay in sync. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> For decades, transactional and analytical workloads have required separate systems kept in sync, adding architectural complexity. LTAP addresses this by unifying both at the stora… [image: Your data.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Your data. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Data AI World Tour 2026 is an upcoming event series focused on how organizations can ground AI in enterprise data and business context to achieve real outcomes. Attendees can expe… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #242 2026-08-18
by pgnexus Aug. 18, 2026

Aug. 18, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Scale pgvector with binary quantization on Amazon Aurora PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Steve Dille Scale pgvector with binary quantization on Amazon Aurora PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> HNSW with binary quantization (HNSW+BQ) in pgvector offers a practical approach for scaling vector search to hundreds of millions or billions of embeddings on Amazon Aurora Postgr… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Query Neon backend logs] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fquery-neo…> Andre Landgraf Query Neon backend logs <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fquery-neo…> Neon has expanded its backend observability tooling by introducing a way to query backend logs outside the Console. The new `neon logs` command reads logs emitted by Neon Function… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fquery-neo…> [image: Highly Available PostgreSQL on Kubernetes in 10 Minutes] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Hans-Jürgen Schönig Highly Available PostgreSQL on Kubernetes in 10 Minutes <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> This tutorial demonstrates deploying a highly available PostgreSQL cluster on Kubernetes using the CYBERTEC PG Operator (CPO) with a minimal 14-line YAML file. Running on minikube… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: Failover slot synchronization in PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Ajin Cherian Failover slot synchronization in PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL 17 introduces failover slot synchronization, a feature that keeps logical replication slots maintained on standby servers. Before this, a failover in a logical replicat… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL Hackers Email Discussion Highlights Support EXCEPT for TABLES IN SCHEMA publications <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABL…> The thread discusses patch v27/v28 adding EXCEPT clause support for TABLES IN SCHEMA publications in PostgreSQL. Peter Smith provides detailed review comments on v27-0001, flaggin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABL…> Fix a relcache reference leak in reorderbuffer.c <https://pgnexus.ai/hacker-discussions?subject=Fix%20a%20relcache%20referenc…> Chao Li reported a relcache reference leak in `reorderbuffer.c`, specifically in the `REORDER_BUFFER_CHANGE_TRUNCATE` branch of `ReorderBufferProcessTXN()`. When `RelationIsLogica… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20a%20relcache%20referenc…> basebackup: do not verify checksums on pages written before enabling checksums <https://pgnexus.ai/hacker-discussions?subject=basebackup%3A%20do%20not%20ve…> The discussion covers a patch to skip checksum verification during base backup for pages written before checksum enabling was initiated. Daniel Gustafsson squashed earlier contrib… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=basebackup%3A%20do%20not%20ve…> pg_control_checkpoint(): add "data_checksum_version" (Pg19)? <https://pgnexus.ai/hacker-discussions?subject=pg_control_checkpoint()%3A%20…> Daniel Gustafsson submitted a rebased patchset adding `data_checksum_version` to `pg_control_checkpoint()`. Bertrand Drouvot reviewed it and raised two test coverage concerns: the… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_control_checkpoint()%3A%20…> datachecksums: handle invalid and dropped databases during enable <https://pgnexus.ai/hacker-discussions?subject=datachecksums%3A%20handle%20i…> Alexander Lakhin reported that a recently added test in `test_checksums/ 001_basic.pl` fails intermittently on slow-storage buildfarm animals (e.g., turaco on Raspberry Pi). The fa… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=datachecksums%3A%20handle%20i…> Residual cleanups for tied objects in PL/Perl <https://pgnexus.ai/hacker-discussions?subject=Residual%20cleanups%20for%20t…> The discussion covers residual cleanup work in PL/Perl related to tied objects. Tom Lane proposed a patch making extension modules use `hek2cstr` for hash entry key conversion, an… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Residual%20cleanups%20for%20t…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-18-postgresql-daily-news-242.…> Industry News [image: Etched's Valuation Doubles to $21B After Jane Street-Led Funding Round] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Etched's Valuation Doubles to $21B After Jane Street-Led Funding Round <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> AI chip startup Etched has seen its valuation double to $21 billion in just one month, following a major new funding round led by Jane Street. The financial firm had previously in… [image: OpenAI Institutes New Safeguards Following Hugging Face Security Breach] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com OpenAI Institutes New Safeguards Following Hugging Face Security Breach <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> OpenAI has announced new security safeguards in response to a breach at Hugging Face. The updated measures include more detailed monitoring of AI models throughout the development… [image: OpenAI Launches Teen-Specific ChatGPT with Safety Controls and Parental Tools] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com OpenAI Launches Teen-Specific ChatGPT with Safety Controls and Parental Tools <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> OpenAI has launched a dedicated version of ChatGPT designed for teenagers, introducing age-appropriate safety measures, parental controls, and learning-focused tools. The product,… Social Media Updates [image: The Year 2038 problem is increasingly less about modern databases and more about the legacy infrastructure surrounding them.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin The Year 2038 problem is increasingly less about modern databases and more about the legacy infrastructure surrounding them. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The Year 2038 problem, which stems from 32-bit Unix timestamp overflow, is no longer primarily a concern for modern databases. PostgreSQL, for example, handles timestamps well bey… linkedin 🏆 At the Databricks Grounded Reasoning Cup, academic teams from Stanford, UMass, Yale and other universities tackled a previously unseen corpus and set of tasks to answer one of the hardest questions in AI evaluation: how well do performance improvements on a benchmark generalize to similar, real-world tasks? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> At the Databricks Grounded Reasoning Cup, academic teams from Stanford, UMass, Yale, and other universities faced an unseen corpus and task set to address a core AI evaluation que… linkedin Getting started with Databricks Apps can be as simple as giving your coding agent the right prompt. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Starting with Databricks Apps can be straightforward using the right prompt for your coding agent. DevHub prompts can check your environment, handle setup, scaffold an app, and de… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #241 2026-08-17
by pgnexus Aug. 17, 2026

Aug. 17, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: LLMs belong in your backend] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fllms-belo…> Carlota Soto LLMs belong in your backend <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fllms-belo…> Neon has introduced the Neon AI Gateway, a feature that integrates LLM calls directly into the Neon backend. Rather than managing separate accounts across multiple AI provider pla… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fllms-belo…> [image: powa-archivist 5.3.0 is out!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org powa-archivist 5.3.0 is out! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> powa-archivist 5.3.0 has been released. This version includes a compatibility fix for PostgreSQL 19, addressing a datatype change in `pg_stat_lock.wait_time` introduced in pg19bet… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: How PostgreSQL CDC Tools Work on YugabyteDB] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.yugabyte.com%2Fblog%2Fp…> Bakul Gupta How PostgreSQL CDC Tools Work on YugabyteDB <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.yugabyte.com%2Fblog%2Fp…> Three popular open-source CDC connectors were tested against YugabyteDB under real-world conditions to evaluate PostgreSQL compatibility. YugabyteDB implements the PostgreSQL wire… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.yugabyte.com%2Fblog%2Fp…> PostgreSQL Hackers Email Discussion Highlights BgBufferSync(): clarification about reusable_buffers variable <https://pgnexus.ai/hacker-discussions?subject=BgBufferSync()%3A%20clarifica…> A patch by Xuneng Zhou aimed at clarifying the `reusable_buffers` variable in `BgBufferSync()` was rebased in May 2025. Ashutosh Bapat, after a significant delay, added the patch… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=BgBufferSync()%3A%20clarifica…> pg_stat_database.checksum_failures misses single-page failures in backups <https://pgnexus.ai/hacker-discussions?subject=pg_stat_database.checksum_fai…> A bug reported by Yilin Zhang and investigated by Zsolt Parragi shows that `pg_stat_database.checksum_failures` is not updated when a base backup encounters exactly one corrupted… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_stat_database.checksum_fai…> Compression of bigger WAL records <https://pgnexus.ai/hacker-discussions?subject=Compression%20of%20bigger%20W…> Surya Poondla reviewed Andrey's v1 patch for compacting WAL records and identified a correctness problem related to the WAL-before-data rule. The patch leaves the page LSN unchang… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Compression%20of%20bigger%20W…> Clarify or fix SIGINT handling in data checksums launcher <https://pgnexus.ai/hacker-discussions?subject=Clarify%20or%20fix%20SIGINT%2…> The discussion concerns clarifying or fixing SIGINT signal handling in the data checksums launcher. Based on the thread, a patch addressing this issue was reviewed and finalized.… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Clarify%20or%20fix%20SIGINT%2…> Optimize UUID parse using SIMD <https://pgnexus.ai/hacker-discussions?subject=Optimize%20UUID%20parse%20usi…> Masahiko Sawada proposed optimizing UUID parsing by reusing the SIMD-accelerated `hex_decode_safe()` in the UUID input function, yielding roughly 5× speedup on canonical UUID form… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Optimize%20UUID%20parse%20usi…> [Patch] Omit virtual generated columns from test_decoding output <https://pgnexus.ai/hacker-discussions?subject=%5BPatch%5D%20Omit%20virtual%…> The patch proposes omitting virtual generated columns from `test_decoding` output. Currently, virtual generated columns appear as `null` in the output, making them indistinguishab… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPatch%5D%20Omit%20virtual%…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-17-postgresql-daily-news-241.…> Industry News [image: Amazon Destroying Rare Books to Train AI Models] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Amazon Destroying Rare Books to Train AI Models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Amazon is reportedly destroying rare books in order to use them as training data for large language models (LLMs). Rare books are considered particularly valuable for AI training… [image: Higgsfield raises $400M Series B, quadrupling its valuation in 8 months to $5.4B] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Higgsfield raises $400M Series B, quadrupling its valuation in 8 months to $5.4B <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Higgsfield, an AI image and video generation startup founded by former Snap executive Alex Mashrabov, has raised a $400 million Series B funding round. The raise quadruples the co… [image: Wispr raises $280M at $2B valuation as it looks beyond dictation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Wispr raises $280M at $2B valuation as it looks beyond dictation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> AI voice startup Wispr has raised $280 million at a $2 billion valuation. The company, known primarily for its dictation tools, is now expanding into new product areas, including… Social Media Updates [image: There is no shortage of PostgreSQL operators for Kubernetes.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin There is no shortage of PostgreSQL operators for Kubernetes. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Despite the many existing PostgreSQL operators for Kubernetes, CYBERTEC has built its own: the CYBERTEC PG Operator. The key differentiator is its focus on multi-site PostgreSQL d… [image: At Databricks, thousands of engineers use coding agents every day, and that makes AI spend one of the fastest-growing line items in R&D.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin At Databricks, thousands of engineers use coding agents every day, and that makes AI spend one of the fastest-growing line items in R&D. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> At Databricks, thousands of engineers rely on coding agents daily, making AI spend one of the fastest-growing R&D costs. The company found a single budget insufficient to manage b… linkedin Databricks customers, get a first look at what's coming to the Databricks Platform. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks is inviting customers to a live product preview event on August 20, hosted by product leaders. The session will cover upcoming updates across several platform areas, in… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #240 2026-08-16
by pgnexus Aug. 16, 2026

Aug. 16, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Residual cleanups for tied objects in PL/Perl <https://pgnexus.ai/hacker-discussions?subject=Residual%20cleanups%20for%20t…> Tom Lane submitted a patch fixing two bugs in PL/Perl: a null pointer dereference in hstore_plperl and an infinite loop in plperl when handling Perl tied objects. These were exclu… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Residual%20cleanups%20for%20t…> Batching in executor <https://pgnexus.ai/hacker-discussions?subject=Batching%20in%20executor> Mats Kindahl responds to Denis Smirnov and Erik's slot-based batching proposal for the PostgreSQL executor. He agrees that TAM interface modifications are unnecessary and that TTS… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Batching%20in%20executor> Make tsqueryout() use a StringInfo <https://pgnexus.ai/hacker-discussions?subject=Make%20tsqueryout()%20use%20a…> Tom Lane proposed replacing `tsqueryout()`'s hand-rolled extensible string buffer with the standard `StringInfo` abstraction, noting the original code was fragile and harder to re… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Make%20tsqueryout()%20use%20a…> [GSoC 2026] - B-tree Index Bloat Reduction - Approach & Questions <https://pgnexus.ai/hacker-discussions?subject=%5BGSoC%202026%5D%20-%20B-tre…> This GSoC 2026 thread discusses a proof-of-concept patch series for B-tree leaf page merging to reduce index bloat. Michail Sirotkin identified a bug where concurrent inserts coul… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BGSoC%202026%5D%20-%20B-tre…> gistkillitems can LP_DEAD-mark the wrong tuples on a rescan <https://pgnexus.ai/hacker-discussions?subject=gistkillitems%20can%20LP_DEAD…> The discussion centers on a bug in `gistkillitems` where LP_DEAD marking can target wrong tuples during a rescan. Peter Geoghegan notes the bug is likely introduced by commit `9c9… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=gistkillitems%20can%20LP_DEAD…> Restructured Shared Buffer Hash Table <https://pgnexus.ai/hacker-discussions?subject=Restructured%20Shared%20Buffe…> The discussion concerns restructuring PostgreSQL's shared buffer hash table for performance. Heikki Linnakangas raised a concern that the buffer header spinlock is held too long d… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Restructured%20Shared%20Buffe…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-16-postgresql-daily-news-240.…> Industry News [image: SpaceX Officially Closes Its Cursor Acquisition] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com SpaceX Officially Closes Its Cursor Acquisition <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> AI coding startup Cursor has officially been acquired by SpaceX, closing a deal that marks a significant expansion for the aerospace company into the AI software tools space. Curs… [image: Anthropic Shares More Details About How Claude's New Watermarks Will Work] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Anthropic Shares More Details About How Claude's New Watermarks Will Work <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Anthropic has released additional details about the watermarking system it is implementing for Claude-generated content. The announcement addresses key technical questions, includ… Social Media Updates [image: I'll be at #Hyderabad #PGDays #2026 next week.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin I'll be at #Hyderabad #PGDays #2026 next week. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The author will speak at Hyderabad PGDays 2026 on Day 2, presenting a session on bringing order and governance to PostgreSQL environments without creating friction for development… [image: 🚀 We're hiring: Mid-Level Full-Stack Engineer (CYPEX) Remote (Europe) | Full-time Ready to level up your career building on top of PostgreSQL?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin 🚀 We're hiring: Mid-Level Full-Stack Engineer (CYPEX) Remote (Europe) | Full-time Ready to level up your career building on top of PostgreSQL? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYPEX is hiring a mid-level full-stack engineer for a fully remote, full-time position open to candidates based in Europe. The role involves building on top of PostgreSQL alongsid… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #239 2026-08-15
by pgnexus Aug. 15, 2026

Aug. 15, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Crash issue in PG18.5 regression <https://pgnexus.ai/hacker-discussions?subject=Crash%20issue%20in%20PG18.5%2…> Jeff Davis is addressing several issues with the `pg_strlower()` API in PostgreSQL 18, following feedback from Andres Freund. Fixes include: improving the severely underdocumented… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Crash%20issue%20in%20PG18.5%2…> Implement waiting for wal lsn replay: reloaded <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> The discussion covers a patchset (6 patches) implementing fixes and cleanups for WAL LSN replay waiting on standby. Key changes include: fixing missing cleanup when auxiliary proc… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Tatsuo Ishii reports a bug in the row pattern recognition (RPR) deparser related to view definitions. When a query uses a subquery workaround to resolve ambiguous column reference… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> basebackup: do not verify checksums on pages written before enabling checksums <https://pgnexus.ai/hacker-discussions?subject=basebackup%3A%20do%20not%20ve…> During a basebackup, pages written before checksums were enabled should not have their checksums verified. Zsolt Parragi submitted a patch; Daniel Gustafsson and Bertrand Drouvot… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=basebackup%3A%20do%20not%20ve…> GIN VACUUM can corrupt internal posting tree pages <https://pgnexus.ai/hacker-discussions?subject=GIN%20VACUUM%20can%20corrupt%…> Peter Geoghegan reports a GIN index corruption bug affecting all stable PostgreSQL branches, originally flagged by Opus 5. The issue is in `ginVacuumPostingTreeLeaves()`: after a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=GIN%20VACUUM%20can%20corrupt%…> Disallow outer-level and WHERE-clause aggregates in GRAPH_TABLE <https://pgnexus.ai/hacker-discussions?subject=Disallow%20outer-level%20and%…> Tom Lane reviewed Sami Imseih's v3 patch for disallowing outer-level and WHERE-clause aggregates in GRAPH_TABLE. While the general pattern of adding EXPR_KIND values was acceptabl… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Disallow%20outer-level%20and%…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-15-postgresql-daily-news-239.…> Social Media Updates linkedin G2 's Summer 2026 report is out, and Databricks earned another top ranking driven by customer feedback! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> G2 has released its Summer 2026 report, in which Databricks secured a top ranking based on customer feedback. The platform received more than 500 five-star reviews, reflecting how… linkedin Turning a hand-drawn sketch into a working dashboard sounds a little like magic 🪄 With Genie Code, you can upload a photo of your sketch and ask it to build the dashboard. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Genie Code is a tool that converts hand-drawn sketches into functional dashboards. Users upload a photo of their sketch, and Genie Code searches available financial data and works… [image: 𝗔𝗜 𝗺𝗮𝘆 𝗯𝗲 𝘁𝗵𝗲 𝗳𝘂𝘁𝘂𝗿𝗲—𝗯𝘂𝘁 𝘆𝗼𝘂𝗿 𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗰𝗼𝘂𝗹𝗱 𝗱𝗲𝘁𝗲𝗿𝗺𝗶𝗻𝗲 𝘄𝗵𝗲𝘁𝗵𝗲𝗿 𝘆𝗼𝘂'𝗿𝗲 𝗿𝗲𝗮𝗱𝘆 𝗳𝗼𝗿 𝗶𝘁.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin 𝗔𝗜 𝗺𝗮𝘆 𝗯𝗲 𝘁𝗵𝗲 𝗳𝘂𝘁𝘂𝗿𝗲—𝗯𝘂𝘁 𝘆𝗼𝘂𝗿 𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗰𝗼𝘂𝗹𝗱 𝗱𝗲𝘁𝗲𝗿𝗺𝗶𝗻𝗲 𝘄𝗵𝗲𝘁𝗵𝗲𝗿 𝘆𝗼𝘂'𝗿𝗲 𝗿𝗲𝗮𝗱𝘆 𝗳𝗼𝗿 𝗶𝘁. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Phillip Merrick, CEO and co-founder of pgEdge, argues that Enterprise PostgreSQL is emerging as a critical foundation for AI adoption. He highlights its role in improving system r… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #238 2026-08-14
by pgnexus Aug. 14, 2026

Aug. 14, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Neon skills landed in the Vercel CLI] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-skil…> Carlota Soto Neon skills landed in the Vercel CLI <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-skil…> Vercel has updated its CLI to automatically install agent skills alongside Marketplace integrations. When a developer runs the command to add Neon as an integration, the CLI now a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-skil…> [image: Continuous Aggregate Refresh, Demystified: Invalidation, Lookback, and Late-Arriving Data] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Damaso Sanoja Continuous Aggregate Refresh, Demystified: Invalidation, Lookback, and Late-Arriving Data <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> A TimescaleDB continuous aggregate uses an invalidation log and a scheduled refresh policy to stay current. Two offsets on the policy—start_offset (lookback window) and end_offset… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights Report index currently being vacuumed in pg_stat_progress_vacuum <https://pgnexus.ai/hacker-discussions?subject=Report%20index%20currently%20…> The discussion concerns a patch (v3) to expose which index each parallel vacuum worker is currently processing in `pg_stat_progress_vacuum`. A key issue arose: `leader_pid` can be… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Report%20index%20currently%20…> Doc update proposal for the note on log_statement in the runtime config for logging page <https://pgnexus.ai/hacker-discussions?subject=Doc%20update%20proposal%20for…> A documentation update proposal for the `log_statement` section in the runtime configuration logging page reached consensus. Daniel Bauman's V3 patch was reviewed by Robert Treat,… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Doc%20update%20proposal%20for…> pgstat: Flush some statistics within running transactions, take 2 <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20st…> Sami Imseih posted a rebased version of the patch for flushing PostgreSQL statistics mid-transaction. Key changes address prior review feedback: index stats are now a separate kin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20st…> CREATE OR REPLACE MATERIALIZED VIEW <https://pgnexus.ai/hacker-discussions?subject=CREATE%20OR%20REPLACE%20MATER…> The discussion centers on whether `CREATE OR REPLACE MATERIALIZED VIEW` is the right syntax for allowing users to update a materialized view's refresh query. Paul Jungwirth raised… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=CREATE%20OR%20REPLACE%20MATER…> Compression of bigger WAL records <https://pgnexus.ai/hacker-discussions?subject=Compression%20of%20bigger%20W…> The discussion covers Andrey Borodin's patch series (now v9) for WAL compression improvements, comprising three patches: reusing zstd contexts for both compression and decompressi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Compression%20of%20bigger%20W…> MERGE/SPLIT PARTITIONS issues/questions <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20…> The discussion focuses on the `MERGE`/`SPLIT PARTITIONS` feature slated for PostgreSQL 19, specifically the silent dropping of partition-specific properties—RLS policies, ACLs, in… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-14-postgresql-daily-news-238.…> Social Media Updates [image: 🚀 We're hiring: Senior Full-Stack Engineer (CYPEX) Remote (Europe) | Full-time If you're a seasoned engineer who loves PostgreSQL, modern web stacks, and shaping products end-to-end, then this one's for you.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin 🚀 We're hiring: Senior Full-Stack Engineer (CYPEX) Remote (Europe) | Full-time If you're a seasoned engineer who loves PostgreSQL, modern web stacks, and shaping products end-to-end, then this one's for you. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYPEX is hiring a Senior Full-Stack Engineer for a full-time remote position open to candidates based in Europe. The role suits experienced engineers with a strong interest in Pos… linkedin Bally's Corporation built Vitruvian, its enterprise Data and AI platform, on Databricks to create a faster, more scalable operating model across its digital and retail gaming business. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Bally's Corporation developed Vitruvian, its enterprise Data and AI platform, on Databricks to unify data, analytics, and machine learning across its digital and retail gaming ope… [image: It's time to scale AI.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin It's time to scale AI. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The Data AI World Tour 2026 is a free, one-day event series coming to multiple cities. It focuses on moving AI from experimentation into production using governed data, models, ap… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #237 2026-08-13
by pgnexus Aug. 13, 2026

Aug. 13, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Neon for Herdr: A Neon pane in your Herdr workspace] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-for-…> Dominik Koch Neon for Herdr: A Neon pane in your Herdr workspace <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-for-…> Dominik Koch has released Neon for Herdr, a plugin that integrates Neon database management directly into the Herdr workspace interface. The plugin adds a dedicated pane displayin… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-for-…> [image: Postgres in Production Special Series: Diagnosing High Cardinality Workloads in pg_stat_statements (Part 6)] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpganalyze.com%2Fblog%2Fpost…> Ryan Booz Postgres in Production Special Series: Diagnosing High Cardinality Workloads in pg_stat_statements (Part 6) <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpganalyze.com%2Fblog%2Fpost…> Part 6 of this series focuses on identifying high-cardinality workloads in pg_stat_statements. A high-cardinality workload occurs when unique normalized queries consistently excee… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpganalyze.com%2Fblog%2Fpost…> [image: PostgreSQL Data Masking: A Technical deep dive into protecting sensitive data] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Diksha Sharma PostgreSQL Data Masking: A Technical deep dive into protecting sensitive data <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Data masking in PostgreSQL allows sensitive data to be obscured while remaining accessible to authorized roles. The article covers practical challenges DBAs face, including handli… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: PostgreSQL 18.6, 17.11, 16.15, 15.19, 14.24 and 19 Beta 3 Released!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PostgreSQL 18.6, 17.11, 16.15, 15.19, 14.24 and 19 Beta 3 Released! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> The PostgreSQL Global Development Group has released updates for all supported versions — 18.6, 17.11, 16.15, 15.19, and 14.24 — along with PostgreSQL 19 Beta 3. This release addr… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights Logical replication row filter loses unchanged toasted columns <https://pgnexus.ai/hacker-discussions?subject=Logical%20replication%20row%2…> A bug was identified where logical replication row filters silently convert unchanged out-of-line (TOASTed) columns to NULL on the subscriber when an UPDATE is transformed into an… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Logical%20replication%20row%2…> Adding pg_dump flag for parallel export to pipes <https://pgnexus.ai/hacker-discussions?subject=Adding%20pg_dump%20flag%20for…> Nitin Motiani (Google) is working on adding a pg_dump flag to support parallel export to pipes. After a rebase that exposed test failures in the previous patch set, he reorganized… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20pg_dump%20flag%20for…> Restructured Shared Buffer Hash Table <https://pgnexus.ai/hacker-discussions?subject=Restructured%20Shared%20Buffe…> Alexandre Felipe is reformatting Dhruv Aron's patch for restructuring the shared buffer hash table, incorporating Andres Freund's feedback to use `instr_time.h` (with rdtsc suppor… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Restructured%20Shared%20Buffe…> Vacuum statistics <https://pgnexus.ai/hacker-discussions?subject=Vacuum%20statistics> The thread discusses v42 of a patch set adding vacuum statistics to PostgreSQL, restructured to flow through the cumulative statistics system. Alexander Korotkov raised concerns a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Vacuum%20statistics> Allow a condition string in an injection point <https://pgnexus.ai/hacker-discussions?subject=Allow%20a%20condition%20strin…> The discussion covers a patch adding condition string matching to PostgreSQL injection points, allowing an injection point to fire only when a provided string matches a configured… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Allow%20a%20condition%20strin…> problems with toast.* reloptions <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20r…> The discussion centers on fixing problems with TOAST table reloptions inheritance in PostgreSQL autovacuum. Nathan Bossart posted v11 to address a compiler warning flagged by cfbo… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20r…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-13-postgresql-daily-news-237.…> Industry News [image: Databricks closes $5B funding round at $190B valuation amid investor surge] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Databricks closes $5B funding round at $190B valuation amid investor surge <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Databricks, the AI and data analytics company, has closed a $5 billion funding round at a $190 billion valuation, far exceeding its original $1 billion target. CEO Ali Ghodsi told… [image: OpenAI introduces 'Ultrafast' mode for GPT-5.6 Sol, targeting enterprise users] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com OpenAI introduces 'Ultrafast' mode for GPT-5.6 Sol, targeting enterprise users <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> OpenAI is launching a preview of "Ultrafast," a new mode for its GPT-5.6 Sol model that operates at 14 times the standard speed. The announcement is aimed at enterprise customers… [image: Anthropic research finds multi-agent AI systems exhibit unexpected conflict and coordination] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Anthropic research finds multi-agent AI systems exhibit unexpected conflict and coordination <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Anthropic researchers have published findings showing that AI agents assigned to the same task can clash, collude, and coordinate in unexpected ways. The study raises new question… Social Media Updates [image: Join Rajneesh Verma , COO, CYBERTEC at Hyderabad PGDays 2026 next week, as he unpacks how to bring order to PostgreSQL environments without slowing teams down.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Join Rajneesh Verma , COO, CYBERTEC at Hyderabad PGDays 2026 next week, as he unpacks how to bring order to PostgreSQL environments without slowing teams down. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Rajneesh Verma, COO of CYBERTEC, will speak at Hyderabad PGDays 2026 on Day 2, August 21, 2026, from 4:00 PM to 4:30 PM in Seminar Hall-1. His session, part of the Postgres Track,… linkedin Google 's latest model, Gemini 3.7 Flash, is now available on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Google's Gemini 3.7 Flash is now available on Databricks. Compared to version 3.6, it offers notable improvements in document parsing and currently leads all Gemini models on Data… linkedin Introducing Smart Routing in Unity AI Gateway. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Unity AI Gateway has introduced Smart Routing, a feature designed to reduce AI costs by automatically matching each coding task to the most suitable model and harness based on tas… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #236 2026-08-12
by pgnexus Aug. 12, 2026

Aug. 12, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Migrate Amazon Aurora PostgreSQL across major versions with active Debezium CDC connectors using native logical replication] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Arko Dutta Migrate Amazon Aurora PostgreSQL across major versions with active Debezium CDC connectors using native logical replication <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> This AWS blog post describes a method for upgrading Amazon Aurora PostgreSQL across major versions while keeping Debezium CDC connectors active, avoiding a full re-snapshot. The a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Neon Functions: backend logic next to your data] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-func…> Carlota Soto Neon Functions: backend logic next to your data <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-func…> Neon has introduced Neon Functions, a compute layer running Node.js 24 that deploys directly onto a Neon branch in the same region as the associated Lakebase Postgres database. Th… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-func…> [image: Introducing the CYBERTEC PG Operator] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Hans-Jürgen Schönig Introducing the CYBERTEC PG Operator <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> CYBERTEC has released the CYBERTEC PG Operator, an open-source Kubernetes operator for PostgreSQL. While existing operators like CloudNativePG, Zalando postgres-operator, Crunchy… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: SynchDB 1.4 Released - Oracle Container Database Support and TLS-Secured FDW Snapshots] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org SynchDB 1.4 Released - Oracle Container Database Support and TLS-Secured FDW Snapshots <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> SynchDB 1.4 has been released, adding Oracle Container Database (CDB/PDB) support across all three Oracle replication paths: Debezium-based CDC, oracle_fdw snapshots, and Openlog… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: plx : Write PostgreSQL functions in the language you already know.] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org plx : Write PostgreSQL functions in the language you already know. <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> plx is a new PostgreSQL extension that allows developers to write stored functions and triggers in familiar languages including Ruby, PHP, JavaScript, Python, TypeScript, Go, COBO… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: Dasha - performance dashboard] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org Dasha - performance dashboard <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> Dasha is an open-source performance dashboard for managing PostgreSQL fleets. It connects using a read-only role with no agents or extensions required on monitored hosts. A single… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: New Modern JDBC Driver for PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org New Modern JDBC Driver for PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> Sehrope Sarkini has released a pre-release JDBC driver for PostgreSQL, written from scratch with a PostgreSQL-first design philosophy. Unlike existing drivers that conform to JDBC… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights LibreSSL and OpenSSL separation in libpq to support 1.1.1 deprecation <https://pgnexus.ai/hacker-discussions?subject=LibreSSL%20and%20OpenSSL%20se…> Daniel Gustafsson proposed implementing LibreSSL as a separate TLS library in libpq, adding fe-secure-libressl.c and be-secure-libressl.c alongside the existing OpenSSL files. Pet… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=LibreSSL%20and%20OpenSSL%20se…> Disallow outer-level and WHERE-clause aggregates in GRAPH_TABLE <https://pgnexus.ai/hacker-discussions?subject=Disallow%20outer-level%20and%…> Sami Imseih identified two gaps in commit f585671055d1, which disallowed aggregates, window functions, and SRFs in GRAPH_TABLE COLUMNS lists. The existing check using pstate->p_ha… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Disallow%20outer-level%20and%…> Split index and table statistics into different types of stats <https://pgnexus.ai/hacker-discussions?subject=Split%20index%20and%20table%2…> Michael Paquier is refactoring PostgreSQL statistics handling to split index and table stats into distinct types. The first patch part is complete; the latest work adds three prev… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Split%20index%20and%20table%2…> Missing list_free in publicationcmds.c:OpenTableList <https://pgnexus.ai/hacker-discussions?subject=Missing%20list_free%20in%20pu…> A fix was proposed for a missing `list_free` call in `publicationcmds.c:OpenTableList`. During review, a suggestion arose to add a comment explaining why `list_free` is not called… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Missing%20list_free%20in%20pu…> problems with toast.* reloptions <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20r…> The thread continues work on fixing TOAST storage parameter (reloption) handling. Nathan Bossart extended the patch set to use `merge_toast_reloptions()` for manual VACUUM as well… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20r…> Re-read conindid under the referenced table's lock in the RI fast path <https://pgnexus.ai/hacker-discussions?subject=Re-read%20conindid%20under%20…'s%20lock%20in%20the%20RI%20fast%20path> A separate thread was created to discuss re-reading `conindid` under the referenced table's lock in the referential integrity (RI) fast path, following a request in a prior discus… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Re-read%20conindid%20under%20…'s%20lock%20in%20the%20RI%20fast%20path> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-12-postgresql-daily-news-236.…> Industry News [image: OpenAI-backed Thrive Holdings raises $2B at $12B valuation for enterprise AI] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com OpenAI-backed Thrive Holdings raises $2B at $12B valuation for enterprise AI <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Thrive Holdings, backed by OpenAI, has secured $2 billion in new funding at a $12 billion valuation. The round attracted major investors including SoftBank, D1 Capital Partners, a… [image: AI coding startup Cognition reportedly in talks to raise at $40B valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com AI coding startup Cognition reportedly in talks to raise at $40B valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> AI coding startup Cognition is reportedly in early talks to raise a new mega funding round at a $40 billion valuation, just months after closing a $1 billion raise at a $26 billio… [image: AI code-testing startup Blacksmith's valuation jumps nearly 10x in under a year] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com AI code-testing startup Blacksmith's valuation jumps nearly 10x in under a year <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> AI code-testing startup Blacksmith has seen its valuation soar nearly tenfold in less than a year, reaching $550 million. The company reports that revenue has also grown more than… Social Media Updates [image: Running a database shouldn't need someone permanently on standby.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Running a database shouldn't need someone permanently on standby. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC PG Operator is an open-source tool designed to automate routine PostgreSQL database management tasks, including setup, scaling, and failure recovery. It aims to reduce th… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0