--- title: "Reflections on recent Postgres events" publication: "Postgres Weekly" issue: 559 published_at: "2024-06-19" canonical_url: "https://postgresweekly.com/issues/559" --- Plus progress on improving the Postgres extension ecosystem, and no-one enjoys vacuuming. | #โ€‹559 โ€” June 19, 2024 [Web Version](https://postgresweekly.com/issues/559) Together with [![Dragonfly\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1296,h_236/e_make_transparent/co_white,e_outline:17/s0zmgewhr5q9s8jl1gfd.png)](https://www.dragonflydb.io/start?utm_campaign=cooperpress_postgres_jun24&utm_source=cooper_press&utm_medium=email&utm_content=Postgres%20Weekly) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/o0qwrjfokr5qhbwfmqhg.jpg)](https://andreas.scherbaum.la/post/2024-06-14_postgresql-development-conference-2024-review/) [A Review of PGConf.dev 2024](https://andreas.scherbaum.la/post/2024-06-14_postgresql-development-conference-2024-review/) โ€” Postgres might have seen [no commits](https://peter.eisentraut.org/blog/2024/06/04/how-engaging-was-pgconfdev-really) during the recent Postgres developer conference, but plenty was happening. This is a really neat and thorough roundup for both those who did and didnโ€™t attend. Andreas 'ads' Scherbaum ๐Ÿ’ก David Wheeler also [shared some notes](https://justatheory.com/2024/06/posette/) about sessions he enjoyed at last week's [POSETTE](https://www.citusdata.com/posette/2024/) event put on by Microsoft. โ–ถ[The State of the Postgres Extension Ecosystem](https://www.youtube.com/watch?v=-6thIB2jw6w) โ€” David Wheeler is overseeing a huge push in the way that Postgres extensions are cataloged, published and distributed, and he gave a talk at POSETTE covering the whys and hows, along with a little history. He also [wrote about the Extension Ecosystem Summit](https://justatheory.com/2024/06/extension-ecosystem-summit/) that took place at PGConfโ€คdev. David Wheeler (Tembo) [![\](https://copm.s3.amazonaws.com/c8d8e97e.png)](https://www.dragonflydb.io/start?utm_campaign=cooperpress_postgres_jun24&utm_source=cooper_press&utm_medium=email&utm_content=Postgres%20Weekly) [Redis With Wings. Better Performance. Less Overhead](https://www.dragonflydb.io/start?utm_campaign=cooperpress_postgres_jun24&utm_source=cooper_press&utm_medium=email&utm_content=Postgres%20Weekly) โ€” Dragonfly (24k GitHub stars) is a fully compatible drop-in Redis replacement. Dragonfly achieves 25X better performance than Redis and supports millions of QPS on a single instance. Download and deploy yourself or get a free trial of Dragonfly Cloud. Dragonfly sponsor [Reduce Vacuuming Using `ON CONFLICT`](https://stborden.wordpress.com/2024/06/18/reduce-vacuum-by-using-on-conflict-directive/) โ€” If you reduce the number of dead tuples caused by failed insert operations, youโ€™ll also reduce the need for Postgres to vacuum the table. Win win. Shane Borden [Identity Crisis: Sequence v. UUID as Primary Key](https://brandur.org/nanoglyphs/026-ids) โ€” _โ€œWhen used mindfully, both integers and UUIDs make quite workable solutions, with (in my opinion) appropriately levered UUIDs edging out a little ahead.โ€_ Brandur Leach **QUICK BITS:** - ๐Ÿ‡ช๐Ÿ‡ธ [Postgres Ibiza](https://pgibz.io/) is back this September and they're [looking for both talks and sponsors.](https://postgresql.fund/blog/postgresql-ibiza-2024-call-for-papers-and-sponsors/) _(The CFP closes on June 23.)_ - Sadly, [OtterTune](https://ottertune.com/), an automated tuning service for Postgres on RDS, has shut down soon after an [acquisition offer that didn't pan out.](https://x.com/andy_pavlo/status/1801687420330770841) - This week's _PostgreSQL Person of the Week_ interviewee [is EDB's William Ivanski.](https://postgresql.life/post/william_ivanski/) [How to Upgrade Postgres.app on macOS](https://til.simonwillison.net/postgresql/upgrade-postgres-app) โ€” [Postgres.app](https://postgresapp.com/) is a popular way to get Postgres instances running quickly on macOS, but what about updating it without losing existing data? Simon Willison ๐Ÿ“„ [From Microsoft SQL Server to PostGIS](https://www.cybertec-postgresql.com/en/microsoft-sql-to-postgis/) โ€“ Even if Postgres alone isnโ€™t enough to tempt SQL Server users, [PostGIS](https://postgis.net/) might be when it comes to spatial datasets! Florian Nadler ๐Ÿ“„ [Compiling Latest gcc to Test More Architectures](https://www.thatguyfromdelhi.com/2024/06/compiling-latest-gcc-to-test-more.html) โ€“ Not a lot to learn here, but neat to see how thoroughly Postgres is tested. Robins Tharakan ๐Ÿ“„ [UUIDv7 Implemented in 20 Languages](https://antonz.org/uuidv7/) โ€“ Yes, even including SQL. Anton Zhiyanov ๐Ÿ“„ [Compiling Postgres with LLVM](https://justatheory.com/2024/06/compile-postgres-llvm/) David Wheeler ๐Ÿ“บ [`pgvector` for Python Developers](https://blog.pamelafox.org/2024/06/pgvector-for-python-developers.html) Pamela Fox ๐Ÿ“ฐ Classifieds ๐Ÿš€ Benefit from [Rocketadminโ€™s](https://rocketadmin.com/?utm_campaign=postgres_weekly) advanced database introspection tech that retrieves all relevant metadata to [create your admin panel](https://rocketadmin.com/?utm_campaign=postgres_weekly)seamlessly. --- Your fastest path to production. [With Render, you can build, deploy, and scale your apps with unparalleled ease](https://render.com?utm_source=cooperpress&utm_medium=cooperpress) โ€“ from your first user to your billionth. --- Did you miss [POSETTE](https://aka.ms/posette-playlist) : An Event for Postgres? Hereโ€™s a [playlist of all 42 talks](https://aka.ms/posette-playlist). Share & like your favorites! ๐Ÿ›  Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/tiqwz2p7jdian0gfk8wn.jpg)](https://blog.pgvecto.rs/pgbestmatchrs-elevate-your-postgresql-text-queries-with-bm25) [pg_bestmatch.rs: Elevate Your Text Queries with BM25](https://blog.pgvecto.rs/pgbestmatchrs-elevate-your-postgresql-text-queries-with-bm25) โ€” [BM25](https://en.wikipedia.org/wiki/Okapi_BM25) is a popular ranking function that can improve full text searches across a large number of documents. [pg_bestmatch.rs](https://github.com/tensorchord/pg_bestmatch.rs) is an extension that brings BM25 related functions and statistics generation into Postgres. Jinjing Zhou - [ActiveRecord::PostgresEnum 2.1](https://github.com/bibendi/activerecord-postgres_enum) โ€“ Integrate Postgres's enum type into Ruby and Rails' _Active Record._ - [River 0.7](https://github.com/riverqueue/river) โ€“ Fast and reliable Postgres-powered background jobs for Go. - [Stateless Postgres Query Router (SPQR) 1.4](https://github.com/pg-sharding/spqr/releases/tag/1.4.0) โ€“ Yandex Cloud's approach to horizontal sharding. - [pgwire 0.23](https://github.com/sunng87/pgwire/releases/tag/v0.23.0) โ€“ The Postgres wire protocol in a Rust library. Now with `COPY`support. - [Piccolo 1.11](https://github.com/piccolo-orm/piccolo) โ€“ User-friendly Python ORM and query builder. **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|*).