<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
  <channel>
    <title>Postgres Weekly</title>
    <description>A weekly email roundup of Postgres news and articles</description>
    <link>https://postgresweekly.com/</link>
    <item>
      <title>Postgres 19 is here (GTA VI can wait)</title>
      <link>https://postgresweekly.com/issues/674</link>
      <description>

  

    
    
    
  




&lt;table border=0 cellpadding=0 cellspacing=0 align="center" border="0"&gt;
  &lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em;"&gt;
  &lt;div&gt;    
    &lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;
&lt;td align="left" style="padding-left: 4px; font-size: 15px; line-height: 1.48em;"&gt;&lt;p&gt;#​674 — November 19, 2026&lt;/p&gt;&lt;/td&gt;
&lt;td align="right" style="padding-right: 4px; font-size: 15px; line-height: 1.48em;"&gt;&lt;p&gt;&lt;a href="https://postgresweekly.com/link/193142/rss" style=" color: #0088bb;"&gt;Web Version&lt;/a&gt;&lt;/p&gt;&lt;/td&gt;
&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
    
    &lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0 12px;"&gt;&lt;p&gt;Postgres Weekly&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/193097/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/wvk9yfa9brpepedo3stv.jpg" width="640" style="    line-height: 1.0em;    "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;&lt;p&gt;Postgres 19 Released&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;It might be GTA VI's release day, but we all know the day's &lt;em&gt;true&lt;/em&gt; big release… &lt;a href="https://postgresweekly.com/link/193097/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Postgres 19 is here&lt;/a&gt;! It's headlined by online table repacking and new ways to keep query plans stable. Some highlights:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/193098/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;&lt;code&gt;REPACK&lt;/code&gt;&lt;/a&gt; reclaims bloat and can reorder a table to match an index, and &lt;code&gt;REPACK (CONCURRENTLY)&lt;/code&gt; does it without blocking reads or writes until the final swap. It supersedes &lt;code&gt;VACUUM FULL&lt;/code&gt; and &lt;code&gt;CLUSTER&lt;/code&gt; (which remain for compatibility).&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;For developers, &lt;a href="https://postgresweekly.com/link/193099/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;&lt;code&gt;INSERT ... ON CONFLICT DO SELECT&lt;/code&gt;&lt;/a&gt; handles 'get or create' in one round trip, &lt;code&gt;COPY&lt;/code&gt; can output JSON, and window functions gain &lt;code&gt;IGNORE NULLS&lt;/code&gt;.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;The &lt;a href="https://postgresweekly.com/link/193100/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;&lt;code&gt;pg_plan_advice&lt;/code&gt;&lt;/a&gt; extension lets you experiment with and guide plan choices, and &lt;a href="https://postgresweekly.com/link/193101/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;&lt;code&gt;pg_stash_advice&lt;/code&gt;&lt;/a&gt; applies advice automatically by query ID, so you can fix a slow plan without changing your app.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;Logical replication can be turned on without a restart, &lt;a href="https://postgresweekly.com/link/193102/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;sequences can now be replicated&lt;/a&gt;, and &lt;a href="https://postgresweekly.com/link/193103/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;&lt;code&gt;WAIT FOR LSN&lt;/code&gt;&lt;/a&gt; gives read-your-writes consistency on standbys.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;And, of course, &lt;a href="https://postgresweekly.com/link/193104/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;much, much more&lt;/a&gt;, all covered in the release notes.&lt;/p&gt;
&lt;p&gt;PostgreSQL Global Development Group&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;div style="   margin-top: 14px; margin-bottom: 8px;  "&gt;&lt;/div&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  &lt;a href="https://postgresweekly.com/link/193096/rss" style=" color: #0088bb;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/48f775ba.png" width="115" height="115" style="padding-top: 12px; padding-left: 12px;     line-height: 100%; "&gt;&lt;/a&gt;
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/193096/rss" title="www.tigerdata.com" style=" color: #0088bb; font-size: 1.1em; line-height: 1.4em;"&gt;Your Partition Maintenance Shouldn’t Be a Cron Job&lt;/a&gt;&lt;/span&gt; — Native partitioning means creating and attaching partitions on a schedule. Hypertables create chunks automatically as data arrives, and compression cuts storage by up to 95% on older ones. Same Postgres. &lt;a href="https://postgresweekly.com/link/193096/rss" style=" color: #0088bb;"&gt;Start on Tiger Cloud with a $1000 credit&lt;/a&gt;.&lt;/p&gt;
  &lt;p&gt;Tiger Data (creators of TimescaleDB) &lt;span style="text-transform: uppercase; margin-left: 4px; font-size: 0.9em;   color: #997 !important; padding: 1px 4px; "&gt;sponsor&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;div style="   margin-top: 14px; margin-bottom: 8px;  "&gt;&lt;/div&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;BEFORE YOU UPGRADE TO POSTGRES 19:&lt;/strong&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;Indexes using full text search, &lt;code&gt;pg_trgm&lt;/code&gt; or &lt;code&gt;fuzzystrmatch&lt;/code&gt; &lt;a href="https://postgresweekly.com/link/193105/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;may need a reindex after &lt;code&gt;pg_upgrade&lt;/code&gt;&lt;/a&gt;. Jeff Davis explains why there's no upgrade check for it.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;code&gt;pg_upgrade --check&lt;/code&gt; &lt;a href="https://postgresweekly.com/link/193106/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;can pass and the upgrade still fail&lt;/a&gt; if a role or database stores &lt;code&gt;standard_conforming_strings = off&lt;/code&gt;, or you've added your own &lt;code&gt;uuid&lt;/code&gt; to &lt;code&gt;bytea&lt;/code&gt; cast (now built in).&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;After a &lt;code&gt;pg_restore&lt;/code&gt;, &lt;a href="https://postgresweekly.com/link/193107/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;run &lt;code&gt;VACUUM ANALYZE&lt;/code&gt;&lt;/a&gt;. Nikolay saw a query take 32.6s instead of 23ms without it, and the first read after a restore can be costly (on 19, particularly).&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/193108/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;JIT is now off by default&lt;/a&gt;, as its cost estimates proved unreliable. If you run a lot of large analytical queries, you may want to turn it back on. &lt;a href="https://postgresweekly.com/link/193109/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;When to JIT?&lt;/a&gt; has more detail on this.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;span&gt;⭐&lt;/span&gt; &lt;a href="https://postgresweekly.com/link/193110/rss" title="www.postgresql.org" style=" color: #0088bb; font-size: 1.05em;"&gt;Postgres 18.7, 17.12, 16.16, 15.20, and 14.25 Released&lt;/a&gt;&lt;/span&gt; — The latest minor releases fix 52 security issues and Postgres 14 goes 'end of life'. &lt;a href="https://postgresweekly.com/link/193111/rss" style=" color: #0088bb;"&gt;Lukas Fittl explains who's exposed&lt;/a&gt; (often any logged-in user) and Devrim Gündüz &lt;a href="https://postgresweekly.com/link/193112/rss" style=" color: #0088bb;"&gt;shows why extensions must be updated with the server&lt;/a&gt;. See &lt;em&gt;"Updating"&lt;/em&gt; for reindexing steps.&lt;/p&gt;
  &lt;p&gt;PostgreSQL Global Development Group &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;IN BRIEF:&lt;/strong&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;The AI-generated bug reports are still flooding in. Christophe Pettus asks people to &lt;a href="https://postgresweekly.com/link/193113/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;stop sending unchecked ones&lt;/a&gt;, and depesz &lt;a href="https://postgresweekly.com/link/193114/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;charts the effect on the lists&lt;/a&gt;.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🎂 Happy 20th birthday to &lt;a href="https://postgresweekly.com/link/193115/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;osm2pgsql&lt;/a&gt;, the tool that loads OpenStreetMap data into Postgres and powers many major OSM maps.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🇺🇸 &lt;a href="https://postgresweekly.com/link/193116/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;PG DATA 2027&lt;/a&gt; takes place June 11–12 in Chicago. The &lt;a href="https://postgresweekly.com/link/193117/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;CFP is open&lt;/a&gt;.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;Microsoft's &lt;a href="https://postgresweekly.com/link/193118/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Azure HorizonDB is now generally available&lt;/a&gt;.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/193119/rss" title="malisper.me" style=" color: #0088bb; font-size: 1.05em;"&gt;Fixing Postgres's Biggest Mistakes&lt;/a&gt;&lt;/span&gt; — Michael follows up his &lt;a href="https://postgresweekly.com/link/193120/rss" style=" color: #0088bb;"&gt;'four horsemen' of Postgres outages&lt;/a&gt; by showing how &lt;a href="https://postgresweekly.com/link/193121/rss" style=" color: #0088bb;"&gt;pgrust&lt;/a&gt;, his team's Rust reimplementation, is tackling certain Postgres shortcomings, from storage that needs no &lt;code&gt;VACUUM&lt;/code&gt; to a planner that learns from its mistakes.&lt;/p&gt;
  &lt;p&gt;Michael Malis &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/193122/rss" title="mehmetince.net" style=" color: #0088bb; font-size: 1.05em;"&gt;How a 22-Year-Old Type Confusion Became RCE&lt;/a&gt;&lt;/span&gt; — Exploiting an extension on a managed Postgres service led Mehmet into core, where changing a composite type's field and reading the old value back became a reliable way to run code. It's one of many reports behind &lt;code&gt;CVE-2026-6460&lt;/code&gt;, fixed in the latest releases (above).&lt;/p&gt;
  &lt;p&gt;Mehmet Ince &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/193123/rss" title="smokentar.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Benchmarking DigitalOcean's New 'Advanced' Managed Postgres&lt;/a&gt;&lt;/span&gt; — DigitalOcean's &lt;a href="https://postgresweekly.com/link/193124/rss" style=" color: #0088bb;"&gt;launch post&lt;/a&gt; teased lower latency and higher throughput, but after 59 hours of benchmarks across 100+ databases, Dimitar found the opposite in his tests.&lt;/p&gt;
  &lt;p&gt;Dimitar Atanasov &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/193125/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Large Postgres Instances Love Huge Pages&lt;/a&gt; – If your &lt;code&gt;shared_buffers&lt;/code&gt; runs to tens of GBs, leaving huge pages unconfigured can cost you 10-20% throughput… &lt;cite&gt;Kaarel Moppel&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/193126/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Ten Ways a &lt;code&gt;glibc&lt;/code&gt; Change Can Break Your Postgres Cluster&lt;/a&gt; – B-tree indexes are just the start, with a way to detect each failure. &lt;cite&gt;Pablo Svampa (Percona)&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/193127/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;How One Pooler Setting Cut a Postgres Server's Memory Use&lt;/a&gt; – A quick PgBouncer tip. &lt;cite&gt;Dinesh Kumar&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/193128/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;How a Broken Release Name Overloaded Sentry's Postgres Database&lt;/a&gt; &lt;cite&gt;Michael Warkentin (Sentry)&lt;/cite&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px;"&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
    &lt;p&gt;📰 Classifieds&lt;/p&gt;
  &lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;🧾 Invoices arriving as PDFs? &lt;a href="https://postgresweekly.com/link/193129/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Foxit’s API&lt;/a&gt; pulls line items, totals, dates and vendors into JSON, ready to load straight into Postgres.&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;RELEASES AND CODE:&lt;/strong&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/193130/rss" title="github.com" style=" color: #0088bb; font-size: 1.05em;"&gt;pgrx 0.20: Build Postgres Extensions in Rust&lt;/a&gt;&lt;/span&gt; — &lt;em&gt;"A big one"&lt;/em&gt; for the framework for building extensions with Rust, which now generates bindings for Postgres's C macros and inline functions automatically, and is Postgres 19 ready.&lt;/p&gt;
  &lt;p&gt;PgCentral Foundation &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;&lt;p&gt;💡 pgrx is now a pretty popular way to build extensions, with ParadeDB's &lt;a href="https://postgresweekly.com/link/193131/rss" style=" color: #0088bb; font-weight: 600;"&gt;pg_search&lt;/a&gt;, Supabase's &lt;a href="https://postgresweekly.com/link/193132/rss" style=" color: #0088bb; font-weight: 600;"&gt;pg_graphql&lt;/a&gt;, Tiger Data's &lt;a href="https://postgresweekly.com/link/193133/rss" style=" color: #0088bb; font-weight: 600;"&gt;pgvectorscale&lt;/a&gt; and &lt;a href="https://postgresweekly.com/link/193134/rss" style=" color: #0088bb; font-weight: 600;"&gt;PostgresML&lt;/a&gt; all built on it.&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/193135/rss" title="gnomon.bitsinfra.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Gnomon: Git-Style Branching/Merging for Postgres Data&lt;/a&gt;&lt;/span&gt; — An extension that brings branches, diffs, merges and undo to data in Postgres, with branches accessible behind different connection strings. New and experimental, and reminds me of the established Postgres-compatible (but &lt;em&gt;not&lt;/em&gt; Postgres) &lt;a href="https://postgresweekly.com/link/193136/rss" style=" color: #0088bb;"&gt;Doltgres&lt;/a&gt;.&lt;/p&gt;
  &lt;p&gt;bitsinfra &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/193137/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;PgDog 0.1.65&lt;/a&gt; – Rust-powered pooler and sharding proxy. Adds cross-shard CTEs and &lt;code&gt;HAVING&lt;/code&gt;, and fixes wrong results from some cross-shard &lt;code&gt;GROUP BY&lt;/code&gt; queries.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/193138/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;Atlas 1.4&lt;/a&gt; – The schema-as-code tool adds &lt;code&gt;atlas security scan&lt;/code&gt; to report CVEs affecting your database servers and extensions.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/193139/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;Postbird 0.9&lt;/a&gt; – A long-dormant open source Postgres GUI returns, rewritten on &lt;a href="https://postgresweekly.com/link/193140/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Electrobun&lt;/a&gt;.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/193141/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;pgAudit 19.0&lt;/a&gt; – The audit logging extension is ready for Postgres 19.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
     
&lt;/div&gt;
  &lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;




&lt;img src="https://postgresweekly.com/open/674/rss" width="1" height="1" /&gt;</description>
      <pubDate>Thu, 19 Nov 2026 00:00:00 +0000</pubDate>
      <guid>https://postgresweekly.com/issues/674</guid>
    </item>
    <item>
      <title>What a random primary key costs in Postgres</title>
      <link>https://postgresweekly.com/issues/673</link>
      <description>

  

    
    
    
  




&lt;table border=0 cellpadding=0 cellspacing=0 align="center" border="0"&gt;
  &lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em;"&gt;
  &lt;div&gt;    
    &lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;
&lt;td align="left" style="padding-left: 4px; font-size: 15px; line-height: 1.48em;"&gt;&lt;p&gt;#​673 — November 11, 2026&lt;/p&gt;&lt;/td&gt;
&lt;td align="right" style="padding-right: 4px; font-size: 15px; line-height: 1.48em;"&gt;&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192768/rss" style=" color: #0088bb;"&gt;Web Version&lt;/a&gt;&lt;/p&gt;&lt;/td&gt;
&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;&lt;p&gt;🕒 Fingers crossed, &lt;strong&gt;the final release of Postgres 19 lands next week&lt;/strong&gt; (Thursday, November 19), so we may hold the next issue back a day or two to cover it properly. If next week's newsletter arrives a little later than usual, that's why. :-)&lt;br&gt;__&lt;br&gt;&lt;em&gt;Your editor, Peter Cooper&lt;/em&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
    
    &lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0 12px;"&gt;&lt;p&gt;Postgres Weekly&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/192694/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/ud1tdm04gaspuqkijouh.jpg" width="640" style="    line-height: 1.0em;    "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192694/rss" title="postgres.ai" style=" color: #0088bb; font-size: 1.1em; line-height: 1.4em;"&gt;UUIDv4 vs UUIDv7: What a Random Primary Key Costs&lt;/a&gt;&lt;/span&gt; — The difference is minimal if the index fits in memory, but grows rapidly as it outgrows the cache! In a memory-constrained benchmark, UUIDv4 inserts ran at two-thirds the rate of an ordered key &lt;em&gt;and&lt;/em&gt; generated more WAL. Nikolay explains why and shares some catches in switching to &lt;code&gt;uuidv7()&lt;/code&gt;.&lt;/p&gt;
  &lt;p&gt;Nikolay Samokhvalov (PostgresAI) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  &lt;a href="https://postgresweekly.com/link/192693/rss" style=" color: #0088bb;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/36027d94.png" width="110" height="110" style="padding-top: 12px; padding-left: 12px;     line-height: 100%; "&gt;&lt;/a&gt;
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192693/rss" title="www.tigerdata.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Your Retention Job Shouldn’t Be a Four-Hour DELETE&lt;/a&gt;&lt;/span&gt; — Purging old rows with DELETE bloats the table, hammers WAL, and leaves VACUUM behind. TimescaleDB partitions by time, so retention drops whole chunks in milliseconds. Same Postgres, same SQL. &lt;a href="https://postgresweekly.com/link/192693/rss" style=" color: #0088bb;"&gt;Start on Tiger Cloud with a $1000 credit&lt;/a&gt;.&lt;/p&gt;
  &lt;p&gt;Tiger Data (creators of TimescaleDB) &lt;span style="text-transform: uppercase; margin-left: 4px; font-size: 0.9em;   color: #997 !important; padding: 1px 4px; "&gt;sponsor&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192695/rss" title="stokerpostgresql.blogspot.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Is Postgres Really Winning?&lt;/a&gt;&lt;/span&gt; — Postgres is the only top four database gaining ground in &lt;a href="https://postgresweekly.com/link/192696/rss" style=" color: #0088bb;"&gt;the DB-Engines rankings&lt;/a&gt; and might pass SQL Server soon, but it measures 'popularity', not production use. In &lt;a href="https://postgresweekly.com/link/192697/rss" style=" color: #0088bb;"&gt;part two&lt;/a&gt;, Dave looks further afield, at developer surveys, acquisitions, and what AI tools reach for by default. In short, things continue to look bright for Postgres.&lt;/p&gt;
  &lt;p&gt;Dave Stokes &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;IN BRIEF:&lt;/strong&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;⏰ &lt;strong&gt;Postgres's quarterly minor releases are due tomorrow&lt;/strong&gt;, alongside Postgres 19 RC2. &lt;a href="https://postgresweekly.com/link/192698/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;The draft announcement&lt;/a&gt; lists 140+ fixes and some post-update reindexing steps. Note that 14.25 will be Postgres 14's final release.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192699/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Xata is joining ClickHouse&lt;/a&gt;, whose Managed Postgres service &lt;a href="https://postgresweekly.com/link/192700/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;went GA&lt;/a&gt; the same day. Meanwhile, &lt;a href="https://postgresweekly.com/link/192701/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;EDB has acquired Altinity&lt;/a&gt;, a major ClickHouse contributor.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;Google has unveiled &lt;a href="https://postgresweekly.com/link/192702/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;AlloyDB Express&lt;/a&gt;, a scale-to-zero tier of its Postgres-compatible database that spins up in seconds and is aimed at prototyping and coding agents. It's in preview, with a free tier.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🗓️ Tomorrow (November 12, 5pm GMT), there's a &lt;a href="https://postgresweekly.com/link/192703/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;free &lt;em&gt;Postgres Meetup for All&lt;/em&gt; online meetup&lt;/a&gt; where Adyen's Huseyin Demir will share what went right and wrong upgrading a huge Postgres fleet to v18 with logical replication.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🇧🇪 The &lt;a href="https://postgresweekly.com/link/192704/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Postgres devroom at FOSDEM 2027&lt;/a&gt; takes place on January 30 in Brussels. The CFP is open until November 28.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192705/rss" title="boringsql.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Why &lt;code&gt;VACUUM&lt;/code&gt; Doesn't Shrink Your Postgres Indexes&lt;/a&gt;&lt;/span&gt; — A page-by-page look, using &lt;code&gt;pageinspect&lt;/code&gt;, at why &lt;code&gt;VACUUM&lt;/code&gt; thins out B-tree index pages but can't shrink the index, and why sequential keys don't refill the gaps. There's also an &lt;a href="https://postgresweekly.com/link/192706/rss" style=" color: #0088bb;"&gt;interactive visualizer&lt;/a&gt; to try it on a tiny tree yourself.&lt;/p&gt;
  &lt;p&gt;Radim Marek &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192707/rss" title="richyen.com" style=" color: #0088bb; font-size: 1.05em;"&gt;An Index Scan Is Only Half the Story: How On-Disk Ordering Affects Performance&lt;/a&gt;&lt;/span&gt; — A look at why an identical index scan can become far slower after a migration involving a parallel data load. Richard shares a &lt;code&gt;ctid&lt;/code&gt; query to help detect the problem.&lt;/p&gt;
  &lt;p&gt;Richard Yen &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192708/rss" title="postgres.ai" style=" color: #0088bb; font-size: 1.05em;"&gt;What Postgres is Waiting For (and Why Dashboards Can't Tell You)&lt;/a&gt;&lt;/span&gt; — Wait event dashboards work by sampling, so they can be right about where time goes overall, yet wrong about why one request is slow.&lt;/p&gt;
  &lt;p&gt;Dmitry Fomin (PostgresAI) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/192709/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;A Database Per Git Worktree That Barely Uses Any Disk Space&lt;/a&gt; – Using Postgres 18's &lt;code&gt;file_copy_method = clone&lt;/code&gt; on a copy-on-write filesystem like APFS or Btrfs. &lt;cite&gt;Dennis Paagman&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/192710/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Our 'Default' &lt;code&gt;postgresql.conf&lt;/code&gt;, Step by Step&lt;/a&gt; – The baseline Data Egret usually starts with when setting up or taking over a cluster, beginning with connection settings. &lt;cite&gt;Ilya Kosmodemiansky (Data Egret)&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📊 &lt;a href="https://postgresweekly.com/link/192711/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Thirteen Small Measurements on Postgres 18&lt;/a&gt; – Such as an unindexed foreign key turning a 13ms cascading delete into a 3.6 second one. &lt;cite&gt;Hollis Varden&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📊 &lt;a href="https://postgresweekly.com/link/192712/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;&lt;code&gt;json&lt;/code&gt; vs &lt;code&gt;jsonb&lt;/code&gt;: Size and Speed, Measured&lt;/a&gt; &lt;cite&gt;Chris van Eijk&lt;/cite&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;RELEASES AND CODE:&lt;/strong&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/192713/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/gsdwwaye2plumcpa5nd4.jpg" width="640" style="    line-height: 1.0em;      "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192713/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;PG Observability Map&lt;/a&gt; – An interactive map of Postgres's architecture &lt;em&gt;(see above)&lt;/em&gt; where you can hover over a component to see which stats views and functions cover it. Inspired by Alexey Lesovsky's &lt;a href="https://postgresweekly.com/link/192714/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;pgstats.dev&lt;/a&gt; diagram (which seems to be down).&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192715/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;Supavisor 2.10&lt;/a&gt; – Supabase's multi-tenant Postgres connection pooler adds a setting to log or reject session-level &lt;code&gt;SET&lt;/code&gt;, &lt;code&gt;LISTEN&lt;/code&gt;, advisory locks and temp tables in transaction mode.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192716/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;PgQueuer 2.0&lt;/a&gt; – A Postgres-backed job queue for Python, built on &lt;code&gt;LISTEN/NOTIFY&lt;/code&gt; and &lt;code&gt;FOR UPDATE SKIP LOCKED&lt;/code&gt;. (&lt;a href="https://postgresweekly.com/link/192717/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Docs&lt;/a&gt;.)&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🔒 &lt;a href="https://postgresweekly.com/link/192718/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;pgx 5.12&lt;/a&gt; – The popular Postgres driver for Go fixes SQL injection in certain simple-protocol batches and a server-authentication bypass affecting some connection settings.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192719/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;pgstream 1.6&lt;/a&gt; – Xata's replication and CDC tool fixes a bug where a restart could skip committed transactions.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px;"&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
    &lt;p&gt;📰 Classifieds&lt;/p&gt;
  &lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;🔍 &lt;a href="https://postgresweekly.com/link/192720/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;A read-only agent for slow Postgres queries&lt;/a&gt;. Faster queries without manual triage, bigger instances, or extra replicas. &lt;a href="https://postgresweekly.com/link/192720/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Free &amp;amp; open source&lt;/a&gt;.&lt;/p&gt;
 
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192721/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;WarpBuild&lt;/a&gt; infrastructure runs GitHub Actions twice as fast at half the cost. &lt;a href="https://postgresweekly.com/link/192721/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Get $50 in free credits&lt;/a&gt; with code &lt;code&gt;START50&lt;/code&gt;.&lt;/p&gt;
 
&lt;p&gt;⚡ &lt;a href="https://postgresweekly.com/link/192722/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Rebase&lt;/a&gt; is an open-source backend for Postgres: REST, auth, realtime and storage, with your access rules enforced by Postgres RLS.&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;AND FINALLY: WHO'S INSIDE THE ELEPHANT?&lt;/strong&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/192723/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/v7qrulepbkg56zf6otkl.jpg" width="640" style="    line-height: 1.0em;      "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192723/rss" title="www.cybertec-postgresql.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Don't Dream It, Be It!&lt;/a&gt;&lt;/span&gt; — Slonik, Postgres's mascot, turns up at many Postgres events, but who's in the suit? At last month's PGConf.EU it was Laurenz Albe, who reports that it's &lt;em&gt;hot&lt;/em&gt;, you can't see your feet, but everybody wants a photo. His advice to first-time attendees who don't know anyone is… volunteer!&lt;/p&gt;
  &lt;p&gt;Laurenz Albe (CYBERTEC) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
     
&lt;/div&gt;
  &lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;




&lt;img src="https://postgresweekly.com/open/673/rss" width="1" height="1" /&gt;</description>
      <pubDate>Wed, 11 Nov 2026 00:00:00 +0000</pubDate>
      <guid>https://postgresweekly.com/issues/673</guid>
    </item>
    <item>
      <title>Postgres 19's built-in bloat cleanup</title>
      <link>https://postgresweekly.com/issues/672</link>
      <description>

  

    
    
    
  




&lt;table border=0 cellpadding=0 cellspacing=0 align="center" border="0"&gt;
  &lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em;"&gt;
  &lt;div&gt;    
    &lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;
&lt;td align="left" style="padding-left: 4px; font-size: 15px; line-height: 1.48em;"&gt;&lt;p&gt;#​672 — November 4, 2026&lt;/p&gt;&lt;/td&gt;
&lt;td align="right" style="padding-right: 4px; font-size: 15px; line-height: 1.48em;"&gt;&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192394/rss" style=" color: #0088bb;"&gt;Web Version&lt;/a&gt;&lt;/p&gt;&lt;/td&gt;
&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
    
    &lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0 12px;"&gt;&lt;p&gt;Postgres Weekly&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/192360/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/fuijuqlp9k2pt4psbneg.jpg" width="640" style="    line-height: 1.0em;    "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192360/rss" title="www.snowflake.com" style=" color: #0088bb; font-size: 1.1em; line-height: 1.4em;"&gt;Postgres 19's &lt;code&gt;REPACK&lt;/code&gt;: Built-In, Online Bloat Cleanup&lt;/a&gt;&lt;/span&gt; — Craig's favorite new Postgres feature is the one he thinks DBAs will care about most. &lt;code&gt;REPACK&lt;/code&gt; folds &lt;code&gt;VACUUM FULL&lt;/code&gt; and &lt;code&gt;CLUSTER&lt;/code&gt; into one command and adds a &lt;code&gt;CONCURRENTLY&lt;/code&gt; mode that keeps the table readable and writable, using logical decoding (a la &lt;a href="https://postgresweekly.com/link/192361/rss" style=" color: #0088bb;"&gt;&lt;code&gt;pg_squeeze&lt;/code&gt;&lt;/a&gt;). He digs into its benefits and how to use it here.&lt;/p&gt;
  &lt;p&gt;Craig Kerstiens (Snowflake) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;&lt;p&gt;⭐ &lt;b&gt;Postgres 19 remains on track for November 19&lt;/b&gt;, with RC2 due on November 12. &lt;a href="https://postgresweekly.com/link/192362/rss" style=" color: #0088bb; font-weight: 600;"&gt;Jonathan Katz has posted the draft press release&lt;/a&gt; for review, and the &lt;a href="https://postgresweekly.com/link/192363/rss" style=" color: #0088bb; font-weight: 600;"&gt;draft release notes&lt;/a&gt; continue to expand.&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  &lt;a href="https://postgresweekly.com/link/192364/rss" style=" color: #0088bb;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/e3350811.png" width="160" height="40" style="padding-top: 12px; padding-left: 12px;     line-height: 100%; "&gt;&lt;/a&gt;
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192364/rss" title="www.enterprisedb.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Sub-Second Personalization on One Lakehouse&lt;/a&gt;&lt;/span&gt; — Live demo: See how EDB Postgres AI delivers sub-second next-best-action on one copy of data in Apache Iceberg. Postgres, WarehousePG and ClickHouse share one catalog, with no pipelines between engines. &lt;a href="https://postgresweekly.com/link/192364/rss" style=" color: #0088bb;"&gt;Watch the demo&lt;/a&gt;.&lt;/p&gt;
  &lt;p&gt;EDB &lt;span style="text-transform: uppercase; margin-left: 4px; font-size: 0.9em;   color: #997 !important; padding: 1px 4px; "&gt;sponsor&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192365/rss" title="boringsql.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Getting Rid of a 4 Terabyte Table Efficiently&lt;/a&gt;&lt;/span&gt; — How do you get rid of a 4 TB table on a primary with ten replicas with as little impact as possible? Radim compares the obvious &lt;code&gt;DROP TABLE&lt;/code&gt; approach against batch deletes and a copy-and-swap, with the measured pros and cons of each.&lt;/p&gt;
  &lt;p&gt;Radim Marek &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;&lt;p&gt;💡 In a similar vein, NexHealth has written up &lt;a href="https://postgresweekly.com/link/192366/rss" style=" color: #0088bb; font-weight: 600;"&gt;how they moved 4 TB &lt;em&gt;out&lt;/em&gt; of a live Postgres database&lt;/a&gt; into its own Aurora cluster with no downtime.&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;IN BRIEF:&lt;/strong&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;Want to ease into contributing to Postgres? Paul Jungwirth is running a &lt;a href="https://postgresweekly.com/link/192367/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;patch review workshop&lt;/a&gt; where small teams will get to review a patch, with committers like Robert Haas critiquing the reviews. You can &lt;a href="https://postgresweekly.com/link/192368/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;sign up here&lt;/a&gt;.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🏴󠁧󠁢󠁳󠁣󠁴󠁿 Jimmy Angelakos &lt;a href="https://postgresweekly.com/link/192369/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;recaps October's &lt;em&gt;Postgres Edinburgh&lt;/em&gt; meetup&lt;/a&gt;, where Elizabeth Christensen covered what's new in Postgres 18 and 19.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;Supabase has opened a &lt;a href="https://postgresweekly.com/link/192370/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;public beta of OrioleDB&lt;/a&gt; and a &lt;a href="https://postgresweekly.com/link/192371/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;private alpha of Multigres&lt;/a&gt;. OrioleDB's alternative Postgres storage engine needs no &lt;code&gt;VACUUM&lt;/code&gt;, but it's not production-ready yet.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192372/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;CloudNativePG is now a CNCF 'incubating' project&lt;/a&gt;. Gabriele Bartolini tells the project's story from its 2019 start at 2ndQuadrant to ~247 million operator downloads today.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192373/rss" title="www.pgedge.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Burnt TOAST: Why DBAs Dread Large Text Columns&lt;/a&gt;&lt;/span&gt; — A tour of how Postgres stores oversized column values, with benchmarks showing why keeping the heap small can speed up scans and updates that leave those values untouched, and why fetching them can still be expensive.&lt;/p&gt;
  &lt;p&gt;Shaun Thomas (pgEdge) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;&lt;p&gt;💡 Sticking to the TOAST theme, Franck Pachot ponders: &lt;a href="https://postgresweekly.com/link/192374/rss" style=" color: #0088bb; font-weight: 600;"&gt;do TOAST's compression and out-of-line thresholds suit&lt;/a&gt; typical JSONB document sizes?&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192375/rss" title="now-next.nl" style=" color: #0088bb; font-size: 1.05em;"&gt;&lt;code&gt;'server closed the connection unexpectedly'&lt;/code&gt; Explained and Measured&lt;/a&gt;&lt;/span&gt; — Chris reproduces connection failures across six clients on Postgres 13, 15, 17 and 18, showing why the same failure produces different diagnostics, and why a lost connection during a &lt;code&gt;COMMIT&lt;/code&gt; can leave the outcome uncertain.&lt;/p&gt;
  &lt;p&gt;Chris van Eijk &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/192376/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Logical Replication Beyond One Writer&lt;/a&gt; – A walkthrough of building multi-region replication, testing failover and handling schema changes, with a runnable Docker lab. &lt;cite&gt;Dimitri Fontaine&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📊 &lt;a href="https://postgresweekly.com/link/192377/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Benchmarking Vector Search in Six Database Engines&lt;/a&gt; – Postgres and pgvector go up against MongoDB, MariaDB, AliSQL and Valkey. &lt;cite&gt;Evgeniy Patlan (Percona)&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/192378/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;How Replication Slots Can Fill Your Disk&lt;/a&gt; &lt;cite&gt;Anugya Sinha (Microsoft)&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/192379/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;How Real is 'Autonomous Postgres'?&lt;/a&gt; &lt;cite&gt;Vibhor Kumar (EDB)&lt;/cite&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px;"&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
    &lt;p&gt;📰 Classifieds&lt;/p&gt;
  &lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;📺 &lt;a href="https://postgresweekly.com/link/192380/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;New 4-hour freeCodeCamp course&lt;/a&gt;: Watch a 1.6-second Postgres query drop to 10 ms with TimescaleDB continuous aggregates.&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;RELEASES AND CODE:&lt;/strong&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/192381/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/okrdnkb2yf4sxr0mofwq.jpg" width="640" style="    line-height: 1.0em;      "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192382/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;pgModeler 2.0&lt;/a&gt; &lt;em&gt;(above)&lt;/em&gt; – Billed as &lt;em&gt;"the biggest release in the history of the project"&lt;/em&gt;, the database modelling tool gets a multi-scene canvas and Postgres 18 support, but moves import, diff and SQL execution to a paid 'Plus' edition.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192395/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;Melange&lt;/a&gt; – Compiles Zanzibar-style, relationship-based authorization from &lt;a href="https://postgresweekly.com/link/192396/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;OpenFGA&lt;/a&gt; models into PL/pgSQL functions, so a permission check is just a &lt;code&gt;SELECT check_permission(...)&lt;/code&gt; away, with no separate service or store.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🌐 &lt;a href="https://postgresweekly.com/link/192383/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;PostGIS 3.7.0&lt;/a&gt; – The geospatial extension (now targeting Postgres 19) adds coverage edges, Float16 rasters and faster &lt;code&gt;ST_DWithin&lt;/code&gt;. Postgres 12/13 support is dropped, and the geocoder and address standardizer move to separate repos.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🔒 &lt;a href="https://postgresweekly.com/link/192386/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;PostgreSQL Anonymizer 3.3&lt;/a&gt; – Dalibo's data-masking extension fixes 12 vulnerabilities and existing users are urged to upgrade.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🔒 &lt;a href="https://postgresweekly.com/link/192387/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;pgAdmin 4 v9.19&lt;/a&gt; – Fixes 15 CVEs. Server-mode users should upgrade, setting two new admin allowlists first.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192384/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;Postgres.js 4.0&lt;/a&gt; – Node.js driver rewritten with a scheduler to stop slow queries blocking fast ones, SCRAM channel binding and two security fixes.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192385/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;TimescaleDB 2.31&lt;/a&gt; – Tiger Data's time-series extension gains a new integer compressor (&lt;em&gt;off by default&lt;/em&gt; for now, but expected to be on by default in 2.32) that can make databases ~10% smaller and typical queries ~50% faster.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192388/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;pg_duckdb 1.2.0&lt;/a&gt; – The DuckDB-in-Postgres extension moves to &lt;a href="https://postgresweekly.com/link/192389/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;DuckDB 2.0&lt;/a&gt; and adds initial Postgres 19 support. It's &lt;em&gt;'not ready for production use'&lt;/em&gt; for now.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192390/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;pg_lion 0.3&lt;/a&gt; – A bitmap-based inverted index type (inspired by &lt;a href="https://postgresweekly.com/link/192391/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;roaring bitmaps&lt;/a&gt;, hence the name!) for faster counts, facets and &lt;code&gt;GROUP BY&lt;/code&gt; on large tables.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192392/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;Reylo 0.7&lt;/a&gt; – Import plain &lt;code&gt;.sql&lt;/code&gt; files into TypeScript with types inferred from your database. From the creator of &lt;a href="https://postgresweekly.com/link/192393/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Zod&lt;/a&gt;.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
     
&lt;/div&gt;
  &lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;




&lt;img src="https://postgresweekly.com/open/672/rss" width="1" height="1" /&gt;</description>
      <pubDate>Wed, 4 Nov 2026 00:00:00 +0000</pubDate>
      <guid>https://postgresweekly.com/issues/672</guid>
    </item>
    <item>
      <title>Why a DBA said no to one column</title>
      <link>https://postgresweekly.com/issues/671</link>
      <description>

  

    
    
    
  




&lt;table border=0 cellpadding=0 cellspacing=0 align="center" border="0"&gt;
  &lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em;"&gt;
  &lt;div&gt;    
    &lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;
&lt;td align="left" style="padding-left: 4px; font-size: 15px; line-height: 1.48em;"&gt;&lt;p&gt;#​671 — October 28, 2026&lt;/p&gt;&lt;/td&gt;
&lt;td align="right" style="padding-right: 4px; font-size: 15px; line-height: 1.48em;"&gt;&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192085/rss" style=" color: #0088bb;"&gt;Web Version&lt;/a&gt;&lt;/p&gt;&lt;/td&gt;
&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
    
    &lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0 12px;"&gt;&lt;p&gt;Postgres Weekly&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/192052/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/fjmq5nbgoygs2qyhpggn.jpg" width="640" style="    line-height: 1.0em;    "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192052/rss" title="mydbanotebook.org" style=" color: #0088bb; font-size: 1.1em; line-height: 1.4em;"&gt;'Region': A Lesson in Data Integrity&lt;/a&gt;&lt;/span&gt; — One of Lætitia's coworkers added a free-text &lt;code&gt;region&lt;/code&gt; column and planned to validate it in app code, but Lætitia wouldn't approve it. Here she makes a case for keeping rules in the database with a look at domains, enums, &lt;code&gt;CHECK&lt;/code&gt; constraints and lookup tables, and how to add constraints on large tables without blocking traffic.&lt;/p&gt;
  &lt;p&gt;Lætitia Avrot &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  &lt;a href="https://postgresweekly.com/link/192051/rss" style=" color: #0088bb;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/9dac2441.png" width="110" height="110" style="padding-top: 12px; padding-left: 12px;     line-height: 100%; "&gt;&lt;/a&gt;
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192051/rss" title="www.tigerdata.com" style=" color: #0088bb; font-size: 1.05em;"&gt;CREATE INDEX on 100M Vectors in Under Two Hours&lt;/a&gt;&lt;/span&gt; — HNSW indexes on large pgvector tables use lots of memory and can take days to build. Meet pg_vectorsearch: an open-source alternative for existing vector columns. At 100M vectors: a 25 GB index and 6 ms queries at 95% recall. &lt;a href="https://postgresweekly.com/link/192051/rss" style=" color: #0088bb;"&gt;See the benchmarks&lt;/a&gt;.&lt;/p&gt;
  &lt;p&gt;Tiger Data (creators of TimescaleDB) &lt;span style="text-transform: uppercase; margin-left: 4px; font-size: 0.9em;   color: #997 !important; padding: 1px 4px; "&gt;sponsor&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;span&gt;📖&lt;/span&gt; &lt;a href="https://postgresweekly.com/link/192053/rss" title="postgrespro.com" style=" color: #0088bb; font-size: 1.05em;"&gt;PostgreSQL 18 Query Optimization: A Free 199-Page Book&lt;/a&gt;&lt;/span&gt; — Postgres Pro's query tuning course, reshaped into a compact book that's now in English. It covers how the planner works, access methods, join strategies, statistics, reading execution plans and tuning approaches. &lt;a href="https://postgresweekly.com/link/192054/rss" style=" color: #0088bb;"&gt;Here's the PDF&lt;/a&gt;.&lt;/p&gt;
  &lt;p&gt;Pavel Tolmachev (PostgresPro) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;IN BRIEF:&lt;/strong&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;Microsoft &lt;a href="https://postgresweekly.com/link/192055/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;has started pitching SQL Server&lt;/a&gt; to Postgres developers as an &lt;em&gt;'upgrade'&lt;/em&gt;, touting its 32,767-connection limit. SQL Server expert &lt;a href="https://postgresweekly.com/link/192056/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Brent Ozar isn't buying it&lt;/a&gt;, and Microsoft's author pops up in the comments to argue back.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🇺🇸 &lt;a href="https://postgresweekly.com/link/192057/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;PgDay Boston 2027&lt;/a&gt; takes place on April 10, 2027 at Tufts University. &lt;a href="https://postgresweekly.com/link/192058/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Registration is open&lt;/a&gt;, as is the &lt;a href="https://postgresweekly.com/link/192059/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;CFP&lt;/a&gt; (until January 15).&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;🇺🇸 &lt;a href="https://postgresweekly.com/link/192060/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Postgres Day SF&lt;/a&gt; is a free meetup (registration needs approval) at PlanetScale's San Francisco office on November 4, celebrating 30 years of Postgres with Bruce Momjian and Fabrizio Mello.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;📅 &lt;a href="https://postgresweekly.com/link/192061/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;POSETTE 2027&lt;/a&gt;, Microsoft's annual virtual Postgres event, returns on March 30-31, 2027. No CFP yet.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192062/rss" title="planetscale.com" style=" color: #0088bb; font-size: 1.05em;"&gt;Why I Don't Trust &lt;code&gt;ON DELETE CASCADE&lt;/code&gt;&lt;/a&gt;&lt;/span&gt; — One big cascading &lt;code&gt;DELETE&lt;/code&gt; plus a routine migration can freeze writes to a table. Tom explains the lock queue behind it, some replication traps, and why he prefers soft deletes.&lt;/p&gt;
  &lt;p&gt;Tom Pang (PlanetScale) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192063/rss" title="www.photoroom.com" style=" color: #0088bb; font-size: 1.05em;"&gt;How a Read Replica Almost Took Down Its Primary Database&lt;/a&gt;&lt;/span&gt; — Google Cloud grows disks automatically so Photoroom wasn't worried about space. Then a backfill left a BI replica so far behind that the primary held 31.7TB of WAL for it. The disk grew close to a hard limit, and shrinking it meant downtime.&lt;/p&gt;
  &lt;p&gt;Marek Zaremba-Pike (Photoroom) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192064/rss" title="www.prisma.io" style=" color: #0088bb; font-size: 1.05em;"&gt;Moving 74GB Off RDS with a Week-Long Rollback Window&lt;/a&gt;&lt;/span&gt; — Prisma moved its console's database off RDS with logical replication and no write pause, then ran replication in &lt;em&gt;reverse&lt;/em&gt; so it could fall back to RDS for a week.&lt;/p&gt;
  &lt;p&gt;Siket and Datta (Prisma) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/192065/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Your App Doesn't Need Postgres Superuser&lt;/a&gt; – Superuser can run commands on the server, so here's what to grant apps and agents instead. &lt;cite&gt;Umair Shahid (Stormatics)&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/192066/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Postgres 19 is Late, and It's AI's Fault&lt;/a&gt; &lt;cite&gt;Robert Haas&lt;/cite&gt;&lt;/p&gt;
&lt;p&gt;📄 &lt;a href="https://postgresweekly.com/link/192067/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Tuning Postgres for Analytics&lt;/a&gt; – Slides and transcript from PGConf.EU on running reports against your app's database without slowing it. &lt;cite&gt;Karen Jex&lt;/cite&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;&lt;p&gt;🎙️ Karen also joined Claire Giordano on the &lt;em&gt;Talking Postgres&lt;/em&gt; podcast to talk about &lt;a href="https://postgresweekly.com/link/192068/rss" style=" color: #0088bb; font-weight: 600;"&gt;her path from Oracle DBA to Postgres contributor&lt;/a&gt;.&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px;"&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
    &lt;p&gt;📰 Classifieds&lt;/p&gt;
  &lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;⚡ &lt;a href="https://postgresweekly.com/link/192069/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Rebase&lt;/a&gt; turns your Postgres into an API and an admin panel your team can use. Our own CRM: 23 tables, zero hand-written admin screens.&lt;/p&gt;
 
&lt;p&gt;⏱️ One 5-row lookup table turned a 0.3 ms Postgres query into 467 ms. &lt;a href="https://postgresweekly.com/link/192070/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;Find yours before prod does&lt;/a&gt;. Now in preview.&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;p&gt;&lt;strong&gt;RELEASES AND CODE:&lt;/strong&gt;&lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/192071/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/ey5jp6aqzwln1cm4yc4d.jpg" width="640" style="    line-height: 1.0em;      "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192071/rss" title="www.pgedge.com" style=" color: #0088bb; font-size: 1.05em;"&gt;pgVolvra: Flashback-Style 'Undo' for Bad &lt;code&gt;UPDATE&lt;/code&gt;s and &lt;code&gt;DELETE&lt;/code&gt;s&lt;/a&gt;&lt;/span&gt; — Trigger-based row history that lets you preview and reverse a bad statement or migration by transaction ID. Plain SQL with no superuser needed, so it works on managed Postgres too. &lt;a href="https://postgresweekly.com/link/192072/rss" style=" color: #0088bb;"&gt;GitHub repo&lt;/a&gt;.&lt;/p&gt;
  &lt;p&gt;Muhammad Aqeel (pgEdge) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192073/rss" title="pgrust.com" style=" color: #0088bb; font-size: 1.05em;"&gt;pgrust 0.4 Beta: The Rust Rewrite of Postgres Opens Up&lt;/a&gt;&lt;/span&gt; — The experimental Rust reimplementation of Postgres adds a new JIT engine, transactional columnar tables and automatic memory sizing (no more &lt;code&gt;work_mem&lt;/code&gt; tuning?).&lt;/p&gt;
  &lt;p&gt;Michael Malis &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;&lt;p&gt;💡 ClickHouse &lt;a href="https://postgresweekly.com/link/192074/rss" style=" color: #0088bb; font-weight: 600;"&gt;pulled pgrust from ClickBench&lt;/a&gt; in September over per-query code and caching. With v0.4's source public, it's &lt;a href="https://postgresweekly.com/link/192075/rss" style=" color: #0088bb; font-weight: 600;"&gt;back in&lt;/a&gt;, and central to a &lt;a href="https://postgresweekly.com/link/192076/rss" style=" color: #0088bb; font-weight: 600;"&gt;benchmark-overfitting debate&lt;/a&gt;.&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;

&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
  
  &lt;p&gt;&lt;span style="font-weight: 600; font-size: 1.1em; color: #000;"&gt;&lt;a href="https://postgresweekly.com/link/192077/rss" title="www.pinecone.io" style=" color: #0088bb; font-size: 1.05em;"&gt;pg_pinecone: Pinecone's Vector Index for pgvector Columns&lt;/a&gt;&lt;/span&gt; — A new extension that indexes existing pgvector columns using IVF and RaBitQ quantization, applying filters during the search. Its native engine runs locally on Postgres 17 and 18, and Pinecone reports a 136MB index vs 2GB for HNSW on 1M vectors. &lt;a href="https://postgresweekly.com/link/192078/rss" style=" color: #0088bb;"&gt;GitHub repo&lt;/a&gt;.&lt;/p&gt;
  &lt;p&gt;Daddala and Mahanna (Pinecone) &lt;/p&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr style="line-height: 1.0em;"&gt;&lt;td style="font-size: 15px; line-height: 1.0em;"&gt;
  &lt;a href="https://postgresweekly.com/link/192079/rss" style=" color: #0088bb; line-height: 1.0em;"&gt;&lt;img src="https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/yerrrdxckhvcxirfirjy.jpg" width="640" style="    line-height: 1.0em;      "&gt;&lt;/a&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style="font-size: 15px; line-height: 1.48em; padding: 0px 15px;"&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192079/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;pg_hdr_histogram 1.0&lt;/a&gt; &lt;em&gt;(above)&lt;/em&gt; – Store value distributions (e.g. latencies) as compact HDR histograms, then query p99-style percentiles and merge them losslessly across time windows or servers, say.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192080/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;mcdview&lt;/a&gt; – Turn a Postgres schema dump (or a Prisma, pgModeler or Rails schema) into a searchable, shareable interactive ER diagram. You can &lt;a href="https://postgresweekly.com/link/192081/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;try it online&lt;/a&gt; or see &lt;a href="https://postgresweekly.com/link/192082/rss" style=" color: #0088bb; font-weight: 500 !important;"&gt;an example of its output here&lt;/a&gt;.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192083/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;Citus 14.3&lt;/a&gt; – The distributed Postgres extension adds sorted-merge execution for multi-shard &lt;code&gt;ORDER BY&lt;/code&gt; queries and per-shard pruning of &lt;code&gt;OR&lt;/code&gt; clauses.&lt;/p&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;a href="https://postgresweekly.com/link/192084/rss" style=" color: #0088bb; font-weight: 500 !important; font-size: 1.08em; line-height: 1.5em;"&gt;SPQR 3.2&lt;/a&gt; – Yandex's Postgres sharding router adds &lt;code&gt;spqrmigrate&lt;/code&gt;, a schema migration tool.&lt;/p&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;table border=0 cellpadding=0 cellspacing=0 border=0 cellpadding=0 cellspacing=0&gt;&lt;tr&gt;&lt;td style=" font-size: 15px; line-height: 1.48em;"&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
     
&lt;/div&gt;
  &lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;




&lt;img src="https://postgresweekly.com/open/671/rss" width="1" height="1" /&gt;</description>
      <pubDate>Wed, 28 Oct 2026 00:00:00 +0000</pubDate>
      <guid>https://postgresweekly.com/issues/671</guid>
    </item>
  </channel>
</rss>
