~postgresweekly | Issue 552 - The future of MySQL is.. Postgres? (8)

node-pg-migrate 7.0: Database Migration Management for Postgres — Lots of cleanups and refactoring from the project’s new maintainer, Shinigami, also a core maintainer of Vite.

PDF: The Future of MySQL is Postgres — The title of this slidedeck certainly caught my eye! It’s a slidedeck from a talk given at Postgres Conference 2024 last week. One of the speakers explains all here. 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...

The Architecture of PGXN v2 — David Wheeler, and others, are working on a major update to the PGXN 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.

Creating 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.

pgddl / ddlx: DDL EXtractor Functions — 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.

ParadeDB: An Elasticsearch Alternative Built on Postgres — Taking the common ‘cloud offering + open source project’ approach, ParadeDB offers an AGPL licensed (repo here) way to speed up Postgres for search and analytics work.

pgvector-remote: A pgvector Fork to Work with Remote Vectors — Pinecone only, for now. There's a blog post introducing the idea.

eBook: Tuning Autovacuum for Best Postgres Performance — 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.