#​552 — April 24, 2024

Web Version

Together with  pgAnalyze

Postgres Weekly

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 alpha release is expected this summer.

Jonah Harris and Mason Sharp

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.

pganalyze sponsor

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.

The PostgreSQL Wiki


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.

Alexander Belanger

📄 The PostgreSQL Community Debates ALTER SYSTEM Jonathan Corbet

📄 How to Calculate Percentiles with PERCENTILE_CONT Vlad Mihalcea

📄 10 psql Commands That Will Make Your Life Easier James Blackwood-Sewell (Timescale)

📄 Complex Zero-Downtime Schema Migrations with ReshapeFabian Lindfors

📄 Operationalizing Vector Databases on Postgres Adam Hendel (Tembo)

📄 Fuzzy Name Matching in Postgres – Getting fuzzy with strings. Paul Ramsey

📰 Classifieds

🗓️ Save the date 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: a serverless queue for your event-driven applications. Learn more.

🛠 Code and Tools

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.

Alexi Theodore

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.

Retake, Inc.

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

Georgia Tech Database Group

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.

Salsita Software

  • PGlite 0.1.5 – Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno.

  • Goose 3.20 – Database migration tool. Supports SQL and Go functions.

  • pgxmock 3.4 – Mock driver to test database interactions in Go.

  • pgrx 0.11.4 – A way to build Postgres extensions with Rust.

  • pgwire 0.21 – The Postgres wire protocol in a Rust library.

  • Slonik 41.1 – Node.js Postgres client with type safety.

  • pspg 5.8.5 – Unix terminal pager for tabular data.