Pgtechweeklyen

Download

pgtechweeklyen@ivorysql.org

May 2026

1 participants
2 discussions

PGNexus Weekly News 2026-05-27
by pgnexus May 27, 2026

May 27, 2026

PGNexus Weekly News This Week in PostgreSQL This week covers PostgreSQL's expanding AI ecosystem, with new extensions enabling transformer inference, Datalog queries, and approximate regex indexing directly inside Postgres. A detailed migration guide helps operators move between Kubernetes-based operators with minimal downtime, while a vector index tradeoff guide addresses practical AI workload decisions. Shardman 18 brings enterprise-grade horizontal sharding to PostgreSQL 18, rounding out a technically rich week for DBAs and developers alike. [image: Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> May 25, 2026 | Slava Sarzhan Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> This blog post provides a detailed technical guide for migrating from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator using the standby cluster method. The migrati… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> [image: The Postgres Developer's Guide to Vector Index Tradeoffs] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> May 26, 2026 | Hien Phan The Postgres Developer's Guide to Vector Index Tradeoffs <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> This comprehensive guide examines vector index selection in PostgreSQL, focusing on four key constraints: memory, recall requirements, write frequency, and filter selectivity. The… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> [image: Postgres Pro Shardman 18 — Review] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> May 25, 2026 | postgrespro.com Postgres Pro Shardman 18 — Review <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> Postgres Pro has released Shardman 18, a sharding extension for PostgreSQL that enables horizontal scaling across multiple nodes. This version introduces improved query planning a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> Top 5 Hacker Discussions Multiple patches and commits are in active progress: WAL reduction efforts include fixes for REPACK CONCURRENTLY accumulation and elimination of xl_heap_visible records, with test stability commits landed. Index prefetching API design debates continue around TupleTableSlot usage versus dedicated interfaces, with code consolidation concerns raised. pg_plan_advice received a corrected fix from Haas. A proposed cleanup for UNLOGGED table entries in publication EXCEPT lists was abandoned after review deemed current behavior acceptable. Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> Vignesh C proposed a patch to handle UNLOGGED table conversions in PostgreSQL publications. The issue occurs when tables listed in publication EXCEPT clauses are converted to UNLO… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> A patch for fixing WAL accumulation during REPACK CONCURRENTLY has been submitted by Zhijie Hou after attending a pgconf.dev talk that clarified this behavior is unintended. The i… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%2…> The discussion centers on eliminating xl_heap_visible WAL records to reduce WAL volume and eventually set visibility map on access. Melanie Plageman committed several fixes to add… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%2…> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan responds to Andres Freund's feedback on index prefetching implementation details. The discussion focuses on API design for index-only scans, particularly whether t… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> pg_plan_advice <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice> Robert Haas responded to Tender Wang's proposed fix for pg_plan_advice, indicating that the suggested solution was not quite correct. The fix had issues with filtering unique reli… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice> This Week's Industry Movements OpenRouter raised $113M at a $1.3B valuation, signaling strong demand for multi-model AI infrastructure as usage surged fivefold in six months. Meanwhile, the Dutch government blocked a US firm from acquiring a cloud provider hosting national digital ID services, highlighting Europe's push for data sovereignty over critical infrastructure. Stord secured $250M to challenge Amazon in e-commerce fulfillment while letting brands retain customer relationships. [image: OpenRouter more than doubles valuation to $1.3B in a year] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com OpenRouter more than doubles valuation to $1.3B in a year <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> OpenRouter has raised a $113 million Series B funding round led by CapitalG, more than doubling its valuation to $1.3 billion within a year. The company provides a platform that a… [image: Dutch government blocks US company from acquisition, citing 'risk to public interest'] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Dutch government blocks US company from acquisition, citing 'risk to public interest' <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> The Dutch government has blocked a US company from acquiring a cloud services provider that hosts the Netherlands' digital ID service, citing risks to public interest. This decisi… [image: Amazon fulfillment competitor Stord raises $250M at $3B valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Amazon fulfillment competitor Stord raises $250M at $3B valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Stord has raised $250 million in funding at a $3 billion valuation, positioning itself as a competitor to Amazon's fulfillment services. The company operates a network of physical… [image: Amazon fulfillment competitor Stord raises $250M at $3B valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Amazon fulfillment competitor Stord raises $250M at $3B valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Stord has raised $250 million in funding at a $3 billion valuation, positioning itself as a competitor to Amazon's fulfillment services. The company operates a network of physical… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Weekly News 2026-05-26
by pgnexus May 26, 2026

May 26, 2026

PGNexus Weekly News This Week in PostgreSQL This week's PostgreSQL highlights include Barman 3.18.0 with experimental block-level incremental cloud backups, pg_tre 1.1.1 introducing approximate regex indexing for PostgreSQL 18+, Postgres Pro Shardman 18 delivering enterprise horizontal scaling, and a practical guide for migrating from Crunchy Data to Percona PostgreSQL Operator with minimal downtime. Together these releases advance backup efficiency, search capabilities, distributed scaling, and Kubernetes operator flexibility. [image: Postgres Pro Shardman 18 — Review] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> May 25, 2026 | postgrespro.com Postgres Pro Shardman 18 — Review <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> Postgres Pro has released Shardman 18, a sharding extension for PostgreSQL that enables horizontal scaling across multiple nodes. This version introduces improved query planning a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> [image: Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> May 25, 2026 | Slava Sarzhan Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> This blog post provides a detailed technical guide for migrating from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator using the standby cluster method. The migrati… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> Top 5 Hacker Discussions Several active development threads addressed pre-beta stabilization concerns. A db-specific snapshot feature for concurrent REPACK was agreed to revert from PostgreSQL 19 and retry in version 20. Index prefetching API design debates continue around slot interfaces and code duplication across table access methods. WAL reduction work targeting xl_heap_visible elimination saw multiple test reliability commits. A pg_plan_advice fix was pushed with a corrected relid filtering implementation. A proposed publication EXCEPT-clause cleanup for UNLOGGED tables was ultimately abandoned. Skipping schema changes in publication <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> Vignesh C proposed a patch to handle UNLOGGED table conversions in PostgreSQL publications. The issue occurs when tables listed in publication EXCEPT clauses are converted to UNLO… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Skipping%20schema%20changes%2…> Adding REPACK [concurrently] <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> The discussion focuses on a patch for database-specific snapshots to enable concurrent REPACK operations. Amit Kapila raises concerns about the architectural implications, noting… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20REPACK%20%5Bconcurre…> eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%2…> The discussion centers on eliminating xl_heap_visible WAL records to reduce WAL volume and eventually set visibility map on access. Melanie Plageman committed several fixes to add… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=eliminate%20xl_heap_visible%2…> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan responds to Andres Freund's feedback on index prefetching implementation details. The discussion focuses on API design for index-only scans, particularly whether t… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> pg_plan_advice <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice> Robert Haas responded to Tender Wang's proposed fix for pg_plan_advice, indicating that the suggested solution was not quite correct. The fix had issues with filtering unique reli… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice> This Week's Industry Movements This week in AI and tech: Google is overhauling Search into a conversational, agent-driven experience that may drastically cut web traffic to publishers. Andrej Karpathy, OpenAI co-founder, joins Anthropic's pre-training team in a major talent win for Claude's development. Meanwhile, a supply-chain attack campaign called Mini Shai-Hulud has compromised dozens of popular open source packages, threatening developers and downstream applications worldwide. [image: Google Search as you know it is over] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Google Search as you know it is over <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Google is fundamentally transforming its Search product from a traditional list of links into an AI-powered experience centered on conversational answers, autonomous agents, and i… [image: OpenAI co-founder Andrej Karpathy joins Anthropic's pre-training team] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com OpenAI co-founder Andrej Karpathy joins Anthropic's pre-training team <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Andrej Karpathy, a co-founder of OpenAI and prominent AI researcher, has joined Anthropic to work on its pre-training team. Pre-training is the phase responsible for large-scale t… [image: Hackers have compromised dozens of popular open source packages] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Hackers have compromised dozens of popular open source packages <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Dozens of popular open source software packages have been compromised in an ongoing supply-chain attack campaign known as Mini Shai-Hulud. The attackers have successfully infiltra… [image: Hackers have compromised dozens of popular open source packages] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> techcrunch.com Hackers have compromised dozens of popular open source packages <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F05%2…> Dozens of popular open source software packages have been compromised in an ongoing supply-chain attack campaign known as Mini Shai-Hulud. The attackers have successfully infiltra… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0