#​546 — March 13, 2024

Web Version

Together with  Hasura

Postgres Weekly

Speeding Up pgvector Queries with Indexes — If you’re using Postgres and pgvector to work with large language embeddings, as is the style at the time, this is a must read. Francesco goes into more detail than you might expect, and you’ll certainly pick up some techniques here.

Francesco Tisiot

Postgres Creator Introduces His New Database Startup — MIT professor Mike Stonebraker was a principal architect of the Postgres project and, aged 80, refuses to rest on his laurels, with a fresh project (DBOS) putting the database closer to the center of the software stack.

Mike Stonebraker

💡 TechCrunch also has a writeup taking a broader, more newsy take.

Instant Realtime GraphQL APIs on PostgreSQL with Hasura — Connect Hasura to your PostgreSQL database and get a secure and highly performant GraphQL API. Query tables and views with filtering, sorting, pagination, aggregations and more. Instantly pull any real-time changes to your data with subscriptions.

Hasura sponsor

▶  The Path to Citus Con: A Podcast for Postgres — The Citus Con event itself is now called POSETTE but the podcast continues under the old name (for now) with monthly episodes digging deep into Postgres topics. The latest episode focuses on the latest around using Postgres in AI and ML use cases, starring Microsoft’s Arda Aytekin along with Claire Giordano and Pino de Candia.

Microsoft podcast

IN BRIEF:

Creating a Postgres Logical Replication System in Go — The folks behind the (Go-powered) Dolt database are working on a feature to replicate data from Postgres, and share what they’ve learnt so far in this particularly detailed post.

Zach Musgrave (Dolthub)

🌐 Using Postgres for (Military) Geoanalytics Tasks — If you dislike military scenarios, skip this, but otherwise it’s a well walked through example of using publicly available data and PostGIS to analyze and plot information of strategic importance (though the powers that be almost certainly do this at 1000x the scale).

Taras Kloba

Enforcing Join Orders in Postgres — With SQL being a declarative language, you'd reasonably expect Postgres to handle the complexities of joining tables in the way you require. It usually does a good job, but there are sometimes reasons to force Postgres to take a different approach..

Hans-Jürgen Schönig

📰 Classifieds

📢 6 critical considerations for evaluating distributed PostgreSQL: New Guide details the implications of Postgres-based vs Postgres compatible.


⚠️ Want to restore lost data? Learn how Neon Point-In-Time Restore helps you recover seconds so you're always prepared when disaster strikes.


Looking to elevate your database skills? Get up to speed with Redgate’s PostgreSQL learning resources hub.

How to Do Performance Testing with pgbench — A straightforward introduction to using pgbench, a benchmarking tool included with Postgres.

Francesco Tisiot

A Postgres Aurora DB Major Version Upgrade with Minimal Downtime
Jay Patel (Lyft)

🛠 Code and Tools

Procrastinate 2.0: Postgres-Based Task Queue for Python — A distributed task processing library for Python that uses Postgres to store task definitions, manage locks and dispatch tasks. Use with Django is a core focus with version 2.0 reworking the Django integration entirely.

Jablon and Lemoine

pgCluu 4.0: Postgres Performance Monitoring and Auditing Tool — A two part tool that collects statistics from a running Postgres cluster and then presents performance information for you to inspect. Version 4.0 is a major release with new features and report types.

Gilles Darold

  • pgAdmin 4 v8.4 – Popular admin platform for Postgres (above).

  • PeerDB 0.11 – Stream data from Postgres to data warehouses, queues and storage engines.

  • PostgresNIO 1.21.0 – Non-blocking, event-driven Postgres client for Swift.

  • Ora2Pg 24.2 – Tooling to migrate from Oracle to Postgres.

  • Prisma 5.11 – Next-gen ORM for Node.js & TypeScript.

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