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

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

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

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

Francesco Tisiot

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