--- title: "An elephant and a duck walk into a bar.." publication: "Postgres Weekly" issue: 604 published_at: "2025-06-19" canonical_url: "https://postgresweekly.com/issues/604" --- Plus now you can watch the talks from PGConf.dev and POSETTE. | #​604 — June 19, 2025 [Web Version](https://postgresweekly.com/issues/604) Together with [![Microsoft logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_280,h_60/e_make_transparent/co_white,e_outline:7/om9hjsmudy5lsvba59eb.png)](https://posetteconf.com/2025/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/sapfz2tfizqacc9feyu5.jpg)](https://motherduck.com/blog/postgres-duckdb-options/) [PostgreSQL and Ducks: The Perfect Analytical Pairing](https://motherduck.com/blog/postgres-duckdb-options/) — [DuckDB](https://duckdb.org/) is an in-process SQL database optimized for OLAP workloads, and it’s gained serious traction in recent years. Pairing it with Postgres opens up opportunities for high performance analytics tasks without the overhead of a full data warehouse or complex ETL pipelines. This post explores the main integration options. Matson and Somani (MotherDuck) ▶[30+ Talks from PGConf.dev 2025 to Enjoy](https://www.youtube.com/playlist?list=PLTw6f6dqzO1tCLr_OHjZ37kY2r35u2tCq#pgconfdev2025) — The talk videos from May’s popular _PostgreSQL Development Conference_ have been getting uploaded over the past couple of weeks and there’s a lot to enjoy, from [how OpenAI scales Postgres](https://www.youtube.com/watch?v=Ni1SGhNu-Q4&list=PLTw6f6dqzO1tCLr_OHjZ37kY2r35u2tCq&index=3) and the [trickiness of building Postgres extensions](https://www.youtube.com/watch?v=0dyBfg-By80&list=PLTw6f6dqzO1tCLr_OHjZ37kY2r35u2tCq&index=28) to [investigating multithreaded Postgres](https://www.youtube.com/watch?v=7BvLaRkaijc&list=PLTw6f6dqzO1tCLr_OHjZ37kY2r35u2tCq&index=26) and [what 10 Postgres contributors did to become a hacker.](https://www.youtube.com/watch?v=e_SyCujZxw0&list=PLTw6f6dqzO1tCLr_OHjZ37kY2r35u2tCq&index=27) PostgreSQL Development Conference [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/efcc9280.png)](https://posetteconf.com/2025/) [Missed POSETTE 2025? Now Watch All 42 Talks on Demand](https://posetteconf.com/2025/) — Learn about the latest features, performance tips, and real-world applications from 45 experts across the PostgreSQL ecosystem. POSETTE: An Event for Postgres is a free & virtual developer event organized by the Postgres team at Microsoft. [Watch now](https://posetteconf.com/2025/). Microsoft sponsor [`SELECT .. FOR UPDATE` Considered Harmful?](https://www.cybertec-postgresql.com/en/select-for-update-considered-harmful-postgresql/) — If `FOR UPDATE` is specified when doing a `SELECT` within a transaction, the selected rows are locked to prevent concurrent updates if you plan to update those rows thereafter. Laurenz notes this lock can be ‘too strong’ for many cases, though, and `FOR NO KEY UPDATE` may be more appropriate and provide sufficient protection. Laurenz Albe **IN BRIEF:** - 🐅 Timescale, the company behind the eponymous [TimescaleDB](https://github.com/timescale/timescaledb) time-series extension, is no more: [it's now called _TigerData_.](https://www.tigerdata.com/blog/timescale-becomes-tigerdata) - 🇦🇺 [PG Down Under 2025](https://conf.pgdu.org/#2025) is an event taking place in Australia this October. Its CFP is open till July 15. - 🇺🇸 We're not even half way through 2025 yet, but if you want a 2026 Postgres event to put on your calendar, [PG Data Conference 2026](https://2026.pg-data.org/) will be taking place in Chicago next June. - Nisha Moond, formerly of Oracle and now on Fujitsu's Postgres team, is [this week's _PostgreSQL Person of the Week_interviewee.](https://postgresql.life/post/nisha_moond/) [Active-Active Replication, Do You Really Need It?](https://percona.community/blog/2025/06/18/postgresql-active-active-replication-do-you-really-need-it/) — Last week we mentioned that [Amazon has open-sourced pgactive](https://aws.amazon.com/about-aws/whats-new/2025/06/open-sourcing-pgactive-active-active-replication-extension-postgresql/), an extension for performing active-active replication. Jan looks at the situations where it might come in useful. Jan Wieremjewicz 📄 [Taking Your First Steps with Logical Replication](https://boringsql.com/posts/logication-replication-introduction/) – A good primer to the basic concepts and techniques. Radim Marek 📄 [How I Dropped the Production Database on a Friday Night](https://vince.beehiiv.com/p/how-i-dropped-the-production-database-on-a-friday-night) – _“Never use `CASCADE` deletes on critical foreign keys.”_ Vincent Josse 📄 [Avoiding Timezone Traps: Correctly Extracting Date/Time Subfields in Django with Postgres](https://www.caktusgroup.com/blog/2025/06/16/avoiding-timezone-traps-correctly-extracting-datetime-subfields-django-postgresql/) Colin Copeland 📺 [The Postgres Developer's Guide to Updates and Deletes in ClickHouse](https://clickhouse.com/videos/postgres-updates-deletes) Mark Needham 📄 [Roman Numeral to Number Conversion and the Fun of Postgres](https://www.cybertec-postgresql.com/en/roman-numerals-in-postgresql-the-fun-of-open-source/) Laurenz Albe 📄 [Checklist: Is Your Postgres Deployment 'Production-Grade'?](https://stormatics.tech/blogs/checklist-is-your-postgresql-deployment-production-grade) Umair Shahid 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/wwxcrqzhrv5anvfbsz6f.jpg)](https://www.youtube.com/watch?v=wzyY7GNV7Xo&list=PLlrxD0HtieHjHHYfXx3llOlESrX1IpJro&index=23) ▶[Introducing Microsoft's VS Code Extension for Postgres](https://www.youtube.com/watch?v=wzyY7GNV7Xo&list=PLlrxD0HtieHjHHYfXx3llOlESrX1IpJro&index=23) — We recently mentioned Microsoft’s announcement of [its new Postgres extension for VS Code](https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-a-new-ide-for-postgresql-in-vs-code-from-microsoft/4414648) and Matt gave a talk at POSETTE including some demos of how to use it. Matt McFarland [XTDB v2: An Immutable SQL Database with Time Travel](https://xtdb.com/blog/launching-xtdb-v2) — An interesting SQL database where _all_ tables are bitemporal (storing both the times data is valid _and_ when it was recorded) and ‘time travel’ is a first-class concern. It’s not related to Postgres, but offers a Postgres-compatible interface to make adoption easier. [GitHub repo.](https://github.com/xtdb/xtdb) Jeremy Taylor (JUXT) [pg_auto_reindexer 1.5: Automatic B-Tree Reindexing Tool](https://github.com/vitabaks/pg_auto_reindexer) — A script that detects and reindexes bloated B-tree indexes with minimal locking by using [`REINDEX CONCURRENTLY`](https://www.postgresql.org/docs/current/sql-reindex.html#SQL-REINDEX-CONCURRENTLY). Vitaliy Kukharik - [qsv 5.1](https://github.com/dathere/qsv/releases/tag/5.1.0) – CLI tool for querying, slicing, filtering, transforming, sorting, and converting tabular data. - [PostgREST 13.0.4](https://github.com/PostgREST/postgrest) – A REST API for any Postgres database. - [Prisma 6.10](https://github.com/prisma/prisma/releases/tag/6.10.0) – Next-gen Node.js + TypeScript ORM. - [pg_dumpbinary v2.20](https://www.postgresql.org/about/news/pg_dumpbinary-v220-released-3084/) **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|*).