Postgres Logging for Performance Optimization — A fantastically thorough article on a topic that’s easy to overlook: logging. Elizabeth walks through the topic from start to finish, covering logging levels, choosing which queries you might want to log, formatting, rotating logs, and ways to process logs once you have them.

Elizabeth Christensen

Dedicated Postgres Performance Workshop for Your Team — Expert-led, dedicated workshop on your database for teams with a meaningful Postgres footprint. Learn to tune slow queries, pick the right indexes, and prevent incidents. New to pganalyze? This is for you. Request today.

pganalyze sponsor

Postgres 17.6, 16.10, 15.14, 14.19, 13.22, and 18 Beta 3 Released — Releases of every supported version of Postgres have landed (as well as a third beta of the forthcoming Postgres 18 – the final release is expected in about a month’s time) in order to tackle a few security vulnerabilities and to deploy numerous bugfixes.

PostgreSQL Global Development Group

Fun and Weirdness with SSDs — An investigation into how query performance can be influenced by SSD quirks in ways the cost model doesn’t anticipate.

Tomas Vondra

Indexing JSONB in Postgres — How do you get the most out of JSONB from a retrieval perspective? Enter Postgres’ rich indexing support.

Craig Kerstiens

VectorChord 0.5: Scalable, Fast, and Disk-Friendly Vector Search — An open-source (AGPLv3 or ELv2) vector search extension for Postgres that offers compatibility with pgvector’s data types and query syntax, but promising a significant performance increase. GitHub repo.

TensorChord Inc.

BemiDB 1.0: Postgres Read Replica Optimized for Analytics — A Snowflake/Fivetran alternative that connects to different data sources, syncs data in a compressed columnar format to S3, and lets you run complex queries using a Postgres-compatible analytical query engine. AGPL 3.0 licensed.

Bemi