--- title: "The only scalable delete is DROP TABLE" publication: "Postgres Weekly" issue: 653 published_at: "2026-06-17" canonical_url: "https://postgresweekly.com/issues/653" --- Plus Microsoft's durable execution extension, and how Postgres user groups can be 'express lanes' for your career. #​653 — June 17, 2026 [Web Version](https://postgresweekly.com/issues/653) Together with [![Tiger Data logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_282/e_make_transparent/co_white,e_outline:30/px1u7kjyvz7xnbm6ytir.png)](https://www.tigerdata.com/events/webinar-cern-2026?utm_source=content-syndication&utm_medium=referral&utm_campaign=cooperpress) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/rl7yc3sauxvwjkycdstt.jpg)](https://andyatkinson.com/postgresql-rds-scaling-aws-christmas-day-peak) [Scaling Postgres to 226k TPS: A Christmas Day Retrospective](https://andyatkinson.com/postgresql-rds-scaling-aws-christmas-day-peak) — A meaty post-mortem and tactical walkthrough of how a digital photo-frame company went from having its Postgres deployment crash out during the 2024 holiday season to handling 2025 without a hitch. Andrew Atkinson [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/377f2e5f.png)](https://www.tigerdata.com/events/webinar-cern-2026?utm_source=content-syndication&utm_medium=referral&utm_campaign=cooperpress) [Learn How CERN Runs 40% Faster Queries on 95% Less Storage](https://www.tigerdata.com/events/webinar-cern-2026?utm_source=content-syndication&utm_medium=referral&utm_campaign=cooperpress) — CERN's 800+ SCADA systems generate hundreds of GB of time-series data daily. See how their engineers achieved 95% storage reduction and 40% faster queries with TimescaleDB — inside Postgres. Jun 25, 9 AM ET. Tiger Data (creators of TimescaleDB) sponsor [The Only Scalable Delete in Postgres is `DROP TABLE`](https://planetscale.com/blog/the-only-scalable-delete) — A reminder that large `DELETE` operations cost more than you think, and how refactoring to a `DROP` or `TRUNCATE` can help in some cases. Tom Pang (PlanetScale) **IN BRIEF:** - Claire Giordano presents a fantastic roundup of [everything new with Postgres at Microsoft](https://techcommunity.microsoft.com/blog/adforpostgresql/whats-new-with-postgres-at-microsoft-2026-edition/4526963) in the past year, from its hosted services to team members' Postgres 19 contributions. - 📺 Microsoft's [POSETTE 2026](https://posetteconf.com/2026/) virtual Postgres conference is taking place _this week_, if you want to check out the livestreams. - [PgDog](https://pgdog.dev/) (an open source connection pooler/sharder) has [raised $5.5m in funding](https://pgdog.dev/blog/our-funding-announcement). - 🇺🇸 [Postgres Summit US](https://2026.postgressummit.us/) is this September 30-October 2 in NYC. They're [looking for volunteers](https://docs.google.com/forms/d/e/1FAIpQLScbgAsSLbvdmx89SsYMDxLM6pkpVNloXmOYWxP9bbdcZBR1vA/viewform) if you'd like to help. - 🇬🇧 Seven spots remain for next week's [London PostgreSQL Meetup Group](https://www.meetup.com/london-postgresql-meetup-group/events/315092418/)session. 🕒 [British Columbia, Time Zones, and Postgres](https://www.crunchydata.com/blog/british-columbia-and-time-zone-changes) — British Columbia [switched to permanent daylight saving time](https://news.gov.bc.ca/releases/2026AG0013-000209) in March, providing an illustration of a subtle `timestamptz` trap: future local times stored _before_ a `tzdata` update come back an hour wrong! Here’s how to avoid getting caught out. Christopher Winslett (Crunchy Data) ▶[How I Got Started Running a Postgres User Group](https://talkingpostgres.com/episodes/how-i-got-started-running-a-postgres-user-group-with-jeremy-schneider) — Jeremy Schneider joined Claire Giordano to discuss why local Postgres user groups are career _“express lanes”_ and why the hard work of running one is worth it. [Full transcript.](https://talkingpostgres.com/episodes/how-i-got-started-running-a-postgres-user-group-with-jeremy-schneider/transcript) Talking Postgres Podcast podcast 💡 The Postgres site maintains [an official list of local user groups](https://www.postgresql.org/community/user-groups/) if you want to find one in your area. 📊 [Write-Heavy `sysbench` Tests on a Large Server: Postgres vs MySQL](https://smalldatum.blogspot.com/2026/06/write-heavy-sysbench-tests-large-server.html) – Mark suspects a performance regression in recent Postgres versions and is trying to figure it out. Mark Callaghan 📄 [A Thousand Postgres Branches for $1](https://xata.io/blog/a-thousand-postgres-branches-for-1) – How Xata drastically improved their database provisioning and branching times. Tudor Golubenco (Xata) 📰 Classifieds 🧩 [New in pgEdge Control Plane](https://github.com/pgEdge/control-plane): deploy MCP, RAG, & PostgREST alongside your DB… + systemd preview. --- When AI writes the data-layer changes, code review stops being a checklist problem. [AgentField](https://agentfield.ai/blog/ai-native-code-review/?utm_source=postgres&utm_medium=newsletter&utm_campaign=postgres-260617&utm_id=postgres-260617-blog-ai-native-code-review&utm_content=blog-ai-native-code-review) breaks down what review becomes in an AI-native engineering team. [→ Read the post](https://agentfield.ai/blog/ai-native-code-review/?utm_source=postgres&utm_medium=newsletter&utm_campaign=postgres-260617&utm_id=postgres-260617-blog-ai-native-code-review&utm_content=blog-ai-native-code-review). **RELEASES AND CODE:** [pg_durable: Durable Execution Inside Postgres](https://github.com/microsoft/pg_durable) — Microsoft has open sourced the durable workflow engine it uses in [Azure HorizonDB](https://azure.microsoft.com/en-gb/products/horizondb). There are two [Docker images](https://github.com/microsoft/pg_durable#packages) running on Postgres 17/18 to experiment with, and [full docs here.](https://learn.microsoft.com/en-gb/azure/horizondb/development/durable-functions) Microsoft [pg_ducklake 1.0: A Native Lakehouse in Postgres](https://pgducklake.select/blog/releasing-v1/) — An extension that brings columnar storage, vectorized execution, and lakehouse architecture (data lake with a catalog) to Postgres, built with DuckDB and [DuckLake](https://ducklake.select/). Relyt - [Nandi 3.0](https://github.com/gocardless/nandi) – A migration tool for _Ruby on Rails_ that keeps routine-looking schema changes from taking your database down on large tables. - [PostgreSQL Anonymizer 3.1](https://www.postgresql.org/about/news/postgresql-anonymizer-31-introducing-local-differential-privacy-3311/) – Now with Local Differential Privacy (LDP) for stronger privacy 'noise'. Also includes a critical security update with all existing users directed to upgrade ASAP. - [pgstream 1.1](https://xata.io/blog/pgstream-v110-steps-towards-turning-it-into-a-service) – Schema change tracking and CDC tool built around logical replication. - 🌐 [osm2pgsql 2.3](https://github.com/osm2pgsql-dev/osm2pgsql) – Import OpenStreetMap data into Postgres/PostGIS. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).