--- title: "They moved from Postgres to MySQL?" publication: "Postgres Weekly" issue: 576 published_at: "2024-11-06" canonical_url: "https://postgresweekly.com/issues/576" --- Plus Aurora's 'limitless' database, the trickiness of Postgres upgrades, and benchmarking Postgres against MySQL. | #​576 — November 6, 2024 [Web Version](https://postgresweekly.com/issues/576) Together with [![Blacksmith\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_820,h_100/e_make_transparent/co_white,e_outline:7/uq9yvkqtinkixhiq19mf.png)](https://blacksmith.sh/?utm_source=cooperpress&utm_medium=exclusive_primary&utm_campaign=nov-06&utm_term=postgres) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/hp4tf2174usd9lpqvgmo.jpg)](https://tembo.io/blog/plug-postgres-upgrade-hole) [Plugging the Postgres Upgrade Hole?](https://tembo.io/blog/plug-postgres-upgrade-hole) — The author claims that community discussions often raise the point that **Postgres is difficult to upgrade** – but is that a fair point? Shaun looks at how Postgres approaches upgrades, limitations in the [`pg_upgrade` approach](https://www.postgresql.org/docs/current/pgupgrade.html), and considers how things could be made better. Shaun Thomas (Tembo) [Migrating In-Place from Postgres to MySQL](https://engineeringblog.yelp.com/2024/10/migrating-from-postgres-to-mysql.html)– (!) — Not the typical migration we’d be talking about here! But Yelp’s status as a heavy user of MySQL played a big role when needing to integrate a Postgres-powered site they acquired. They had to make some compromises due to Postgres-specific functionality, but with few Postgres skills in-house, they deemed it a necessary sacrifice. Alex Toumazis (Yelp) [![\](https://copm.s3.amazonaws.com/10345b95.png)](https://blacksmith.sh/?utm_source=cooperpress&utm_medium=exclusive_primary&utm_campaign=nov-06&utm_term=postgres) [Run GitHub Actions Up to 2x Faster at Half the Cost](https://blacksmith.sh/?utm_source=cooperpress&utm_medium=exclusive_primary&utm_campaign=nov-06&utm_term=postgres) — Blacksmith runs your GitHub Actions substantially faster by running them on modern gaming CPUs. Integrating Blacksmith is a one-line code change. 100+ companies like Ashby, Superblocks, and Slope use Blacksmith to help developers merge code faster. Blacksmith sponsor [_Amazon Aurora PostgreSQL Limitless Database_ Generally Available](https://aws.amazon.com/blogs/aws/amazon-aurora-postgresql-limitless-database-is-now-generally-available/) — A new way to horizontally scale/shard Amazon Aurora to extend a database beyond Aurora’s typical storage and write throughput limits while still looking and feeling like a single database. It’s now GA with Postgres 16.4 compatibility. Channy Yun (AWS) **QUICK BITS:** - [postgres-contrib.org](https://postgres-contrib.org/) is a blog rounding up contributions made to the Postgres project on a mostly weekly basis. - 🗓️ The [PostgreSQL Event Calendar](https://ics.postgresql.life/) is a site keeping track of Postgres-oriented events and also hosts an ICS / iCalendar file you can add to your own calendar app. - [EDB's Rushabh Lathia](https://postgresql.life/post/rushabh_lathia/) is this week's _PostgreSQL Person of the Week_interviewee. [Vector Databases are the Wrong Abstraction](https://www.timescale.com/blog/vector-databases-are-the-wrong-abstraction/) — When it comes to semantic search, Timescale thinks that externally producing embedding vectors and then putting them into a database is the wrong approach, and that embeddings should be treated more like database indexes and handled _by_ the database. [_Pgai Vectorizer_](https://github.com/timescale/pgai/blob/main/docs/vectorizer.md) is their attempt at making this a reality. Arye and Sewrathan (Timescale) [Benchmarking Postgres vs MariaDB and MySQL](https://datasystemreviews.com/fastest-open-source-databases.html) — Using a custom-built benchmarking tool, [Reserva](https://github.com/calmitchell617/reserva), the author found Postgres leads the way, performance-wise. Usual disclaimers about the troubles of benchmarking and getting accurate results, etc. etc.. Cal Mitchell 📄 [Poking Around Postgres Full-Text Search: A Primer](https://remimercier.com/postgresql-full-text-search-for-beginners/) – Focuses on the classic `tsvector`/`tsquery` approach and associated functions. Rémi Mercier 📄 [Avoid Capital Letters in Postgres Names](https://weiyen.net/articles/avoid-capital-letters-in-postgres-names) – It just saves a lot of headaches.. Wei Yen 📄 [The Top 5 Key Differences Between SQL Server and Postgres](https://www.sqlpassion.at/archive/2024/10/09/the-top-5-key-differences-between-sql-server-and-postgresql/) Klaus Aschenbrenner 📄 [Why You Do Not Want to Use the C/POSIX Locale](https://thebuild.com/blog/2024/10/30/an-interlude-why-you-do-not-want-to-use-cposix-locale/) Christophe Pettus 📄 [Why `pg_dump` is Amazing](https://rhaas.blogspot.com/2024/11/why-pgdump-is-amazing.html) Robert Haas 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/mj8pvyxrgdnaf7mqntet.jpg)](https://www.pgflo.io/) [pg_flo: Stream, Transform, and Route Postgres Data in Real-time](https://www.pgflo.io/) — Offers a set of filters and transformations that can make moving data between, say, production and staging databases simple using one of two modes: copy-and-stream or stream-only. Uses NATS and Postgres’s replication. Shayon Mukherjee [OneSparse: Accelerated Sparse Linear Algebra for Postgres](https://github.com/OneSparse/OneSparse) — Like JSON/JSONB types did for unstructured data, OneSparse wants to make dense and sparse matrices and vectors fully native Postgres types along with optimized parallel matrix multiplication and other operations like reduction, selection, assignment, extraction, element-wise union, and intersection. Michel Pelletier [pgCompare: A Java App to Check Post-Replication Data Consistency](https://github.com/CrunchyData/pgCompare) — If you’re moving data from one database to another, say, you can use this to perform a comparison to check the integrity of the migration. Crunchy Data [ProxySQL Expands Database Support to Postgres](https://proxysql.com/blog/proxysql-expands-database-support-to-postgresql-in-version-3-0-0-alpha/) — [ProxySQL](https://proxysql.com/) is an open source MySQL proxy that has, now, introduced Postgres support in anticipation of its v3.0 release. [v3.0.0-alpha](https://github.com/sysown/proxysql/releases/tag/v3.0.0-alpha) is now available for testing. ProxySQL LLC 📰 Classifieds 🧐 Struggling with slow Postgres queries? [Join our Nov. 13 webinar to see how pganalyze](https://events.zoom.us/ev/ApbJR2G425JREX5RY0tXPfOpswNrI39-sSvOOTH9CgccsUQqdS5X~AjIQkJgpKG4Lk0KOSMmIIULvI7xv3Y614gDjCH3FfNPkFJswVqv6FQ3rb9ut9OympU-ceNNebOI_mCh5vBl2fJONtA%20) simplifies EXPLAIN plan comparisons to debug common issues. [pg-dump-parser: Parses Postgres Dump Files into Arrays of Schema Objects](https://github.com/gajus/pg-dump-parser) — Takes a Postgres database dump, splits it up, and turns the table and view structures into a format you can more easily work on from code (or just use as a reference or check into version control). Gajus Kuizinas [rusty_psql: A `psql` Wrapper for Getting Credentials from Azure Key Vault](https://github.com/kometen/rusty_psql) Claus Guttesen - [pgwire 0.26](https://github.com/sunng87/pgwire) – The Postgres wire protocol implemented in a Rust library. - [Rest 0.2](https://rest-go.com/) – Serve a fully RESTful API from SQL databases. - [PeerDB 0.19](https://github.com/PeerDB-io/peerdb) – Stream data from Postgres to data warehouses, queues and storage engines. - [PostgreSQL-OCaml 5.1](https://github.com/mmottl/postgresql-ocaml) – Postgres bindings for OCaml. - [PostgreSQL Build Farm Client v18](https://adpgtech.blogspot.com/2024/11/announcing-release-18-of-postgresql.html) **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|*).