Waiting for Postgres 16: Cumulative I/O Statistics with pg_stat_io — A look at querying system-wide I/O statistics in future versions of Postgres using the new pg_stat_io view, several use cases for it, and thoughts on the future of I/O observability in Postgres generally.

Lukas Fittl

Exposing Postgres Performance Secrets — Long standing Postgres expert Craig lays out four basic things to set up today to make finding and fixing performance issues faster in the future.

Craig Kerstiens

Download PostgreSQL High Availability Architectures — Yours for free. Percona architectures are built with only battle-tested open source components and designed to ensure up to 99.9% availability. Architectures are available for businesses of every size.

Percona sponsor

Storing OpenAI Embeddings in Postgres with pgvector — An example of how to build a machine learning-powered search engine using OpenAI’s embeddings and Postgres. The idea is you compress sentences (in this case) down into vectors, store those vectors, then query against them – something that pgvector can help you with.

Greg Richardson (Supabase)

Working with Rankings with SQL Window Functions — A handy, easy to follow tutorial on making ratings and dividing data into partitions extracted from Anton’s SQL Window Functions Explained book.

Anton Zhiyanov

Finding the Current Timestamp — You think it’d be easy to establish what the time is, but there are a few options. Learn more about real time, statement time and transaction time.

Hans-Jürgen Schönig

Debugging WAL Events with pg_walinspect — pg_walinspect is a module supplied with Postgres for looking into the contents of the write-ahead log.

Anthony Sotolongo

pgpq: Stream Arrow / Parquet Data into Postgres — A new ‘proof of concept stage’ library for streaming Arrow RecordBatches to Postgres in order to bulk load Parquet files. Written in Rust.

Adrian Garcia Badaracco

SQL Notebook: Casual Data Exploration in SQL — Import data from CSV, Excel, Microsoft SQL Server, Postgres, and MySQL. Use a Jupyter-style notebook interface for exploratory queries, and write stored procedures for reusable logic.

Brian Luft

Postgres Message Queue (PGMQ) — A lightweight distributed message queue on Postgres as an extension. Written in Rust and lives as part of the CoreDB Postgres distribution.

CoreDB