~postgresweekly | Issue 546 - pgvector Indexes and Optimizations (10)

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.

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

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

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.

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.

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

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.

🌐 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).

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.

Procrastinate 1.1: Postgres-Based Task Queue for Python — A distributed task processing library for Python 3.8+ that uses Postgres to store task definitions, manage locks, and dispatch tasks. It can be used in both sync and async code, as well as in Django apps. GitHub repo.