--- title: "The future of MySQL is.. Postgres?" publication: "Postgres Weekly" issue: 552 published_at: "2024-04-24" canonical_url: "https://postgresweekly.com/issues/552" --- Plus the future of extension distribution, PGDay UK opens its CFP, and what went down with ALTER SYSTEM. | #​552 — April 24, 2024 [Web Version](https://postgresweekly.com/issues/552) Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://pganalyze.com/ebooks/tuning-postgres-autovacuum?utm_source=PostgresWeeklyPrimary04242024) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/eptvqhqvvax5evxaxp2q.jpg)](https://nextgres.com/res/20240419-The-Future-of-MySQL-is-Postgres.pdf) PDF: [The Future of MySQL is Postgres](https://nextgres.com/res/20240419-The-Future-of-MySQL-is-Postgres.pdf) — The title of this slidedeck certainly caught my eye! It’s a slidedeck from a talk given at [Postgres Conference 2024](https://postgresconf.org/conferences/2024) last week. One of the speakers [explains all here](https://news.ycombinator.com/item?id=40094160). They’re working on a Postgres extension to enable MySQL apps to run on Postgres without any code changes (so it’ll support the wire protocol, SQL dialect, etc.) An alpha release is expected this summer. Jonah Harris and Mason Sharp [![\](https://copm.s3.amazonaws.com/116f9247.png)](https://pganalyze.com/ebooks/tuning-postgres-autovacuum?utm_source=PostgresWeeklyPrimary04242024) [eBook: Tuning Autovacuum for Best Postgres Performance](https://pganalyze.com/ebooks/tuning-postgres-autovacuum?utm_source=PostgresWeeklyPrimary04242024) — Learn about tuning settings for scheduling and performance, reducing autovacuum overhead during business hours, the xmin horizon and how it blocks vacuums, why to avoid anti-wraparound vacuums and how to reduce bloat by tuning dead tuple thresholds. pganalyze sponsor [The Architecture of PGXN v2](https://wiki.postgresql.org/wiki/PGXN_v2/Architecture) — David Wheeler, and others, are working on a major update to the [PGXN](https://pgxn.org/) approach to providing extension distribution, discovery, and tooling for the Postgres ecosystem. This new wiki page outlines the current state of play and where things could head next. The PostgreSQL Wiki **IN BRIEF:** - 🇬🇧 [PGDay UK](https://2024.pgday.uk/) has announced its [return — in London, on September 11](https://pgday.uk/events/pgdayuk2024/news/pgday-uk-2024-its-back-on-september-11th-in-london-england-8/). Their [CFP is also open](https://2024.pgday.uk/call-for-papers/) if you want to speak. - Microsoft's Claire Giordano [explains the talk selection process for POSETTE](https://www.citusdata.com/blog/2024/04/22/about-talk-selection-for-posette-an-event-for-postgres-2024/), the annual virtual Postgres conference. They got 184 talk proposals but can only accept 38, so there's a lot of work to be done. [Creating Multi-Tenant Queues](https://docs.hatchet.run/blog/multi-tenant-queues) — Spinning up a basic queue on Postgres is reasonably easy, but what about if you don’t want one user’s jobs hogging the limelight? Make things more fair with separate queues for each user. Alexander Belanger 📄 [The PostgreSQL Community Debates `ALTER SYSTEM`](https://lwn.net/Articles/968300/) Jonathan Corbet 📄 [How to Calculate Percentiles with `PERCENTILE_CONT`](https://vladmihalcea.com/sql-percentile-cont/) Vlad Mihalcea 📄 [10 `psql` Commands That Will Make Your Life Easier](https://www.timescale.com/blog/10-psql-commands-that-will-make-your-life-easier/) James Blackwood-Sewell (Timescale) 📄 [Complex Zero-Downtime Schema Migrations with Reshape](https://fabianlindfors.se/blog/complex-schema-migrations-with-reshape/) – Fabian Lindfors 📄 [Operationalizing Vector Databases on Postgres](https://tembo.io/blog/operationalizing-vectordbs-on-postgres) Adam Hendel (Tembo) 📄 [Fuzzy Name Matching in Postgres](https://www.crunchydata.com/blog/fuzzy-name-matching-in-postgresql) – Getting fuzzy with strings. Paul Ramsey 📰 Classifieds 🗓️ [Save the date](https://www.addevent.com/event/AE19906747) for POSETTE: A free, virtual developer event for Postgres (Jun 11-13). Join 44 speakers across 4 unique livestreams to hear from PG experts. Schedule is out May 1. --- 🪝 [Hookdeck](https://hookdeck.com?ref=nodeweekly-529): a serverless queue for your event-driven applications. [Learn more](https://hookdeck.com?ref=nodeweekly-529). 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/tvtuulraerdgp0odk66n.jpg)](https://github.com/lacanoid/pgddl) [pgddl / ddlx: DDL EXtractor Functions](https://github.com/lacanoid/pgddl) — An SQL-only extension that can create SQL DDL (e.g. `CREATE TABLE`) for system catalogs / table schemas, etc. since using `pg_dump` doesn’t suit every scenario. Alexi Theodore [ParadeDB: An Elasticsearch Alternative Built on Postgres](https://www.paradedb.com/) — Taking the common ‘cloud offering + open source project’ approach, ParadeDB offers an AGPL licensed ([repo here](https://github.com/paradedb/paradedb)) way to speed up Postgres for search and analytics work. Retake, Inc. [pgvector-remote: A pgvector Fork to Work with Remote Vectors](https://github.com/georgia-tech-db/pgvector-remote) — Pinecone only, for now. There's [a blog post](https://medium.com/@sweta.vooda/pgvector-remote-a-pgvector-fork-with-the-performance-of-pinecone-5d8a7f6a50bd) introducing the idea. Georgia Tech Database Group [node-pg-migrate 7.0: Database Migration Management for Postgres](https://github.com/salsita/node-pg-migrate/releases/tag/v7.0.0) — Lots of cleanups and refactoring from the project’s new maintainer, Shinigami, also a core maintainer of Vite. Salsita Software - [PGlite 0.1.5](https://github.com/electric-sql/pglite) – Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno. - [Goose 3.20](https://github.com/pressly/goose) – Database migration tool. Supports SQL and Go functions. - [pgxmock 3.4](https://github.com/pashagolub/pgxmock) – Mock driver to test database interactions in Go. - [pgrx 0.11.4](https://github.com/pgcentralfoundation/pgrx/releases/tag/v0.11.4) – A way to build Postgres extensions with Rust. - [pgwire 0.21](https://github.com/sunng87/pgwire) – The Postgres wire protocol in a Rust library. - [Slonik 41.1](https://github.com/gajus/slonik) – Node.js Postgres client with type safety. - [pspg 5.8.5](https://github.com/okbob/pspg) – Unix terminal pager for tabular data. **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|*).