#559 — June 19, 2024 |
|
Postgres Weekly |
|
|
A Review of PGConf.dev 2024 — Postgres might have seen no commits 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 about sessions he enjoyed at last week's POSETTE event put on by Microsoft. |
|
▶ The State of the Postgres Extension Ecosystem — 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 that took place at PGConf․dev. David Wheeler (Tembo) |
Redis With Wings. Better Performance. Less Overhead — 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 Shane Borden |
|
Identity Crisis: Sequence v. UUID as Primary Key — “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:
|
|
How to Upgrade Postgres.app on macOS — Postgres.app 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 – Even if Postgres alone isn’t enough to tempt SQL Server users, PostGIS might be when it comes to spatial datasets! Florian Nadler 📄 Compiling Latest gcc to Test More Architectures – Not a lot to learn here, but neat to see how thoroughly Postgres is tested. Robins Tharakan 📄 UUIDv7 Implemented in 20 Languages – Yes, even including SQL. Anton Zhiyanov 📄 Compiling Postgres with LLVM David Wheeler 📺 |
|
🛠 Code and Tools |
|
|
pg_bestmatch.rs: Elevate Your Text Queries with BM25 — BM25 is a popular ranking function that can improve full text searches across a large number of documents. pg_bestmatch.rs is an extension that brings BM25 related functions and statistics generation into Postgres. Jinjing Zhou |
|
|
Got a new email? You can change your address here. Bored of us? Click here to stop getting Postgres Weekly. 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. Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. |