pgPedia: A Postgres Encyclopedia of Sorts — An interesting, cleanly formatted wiki-esque reference guide to Postgres’ features and settings that complements the official documentation well. Well worth poking around a bit.

Postgrespedia

🎧 Say Hello to the Talking Postgres Podcast — The Path to Citus Con podcast was created to promote Citus Con (now POSETTE) by way of interviews with speakers and other Postgres luminaries, but has turned into a great Postgres podcast generally. To reflect this growth, it’s had a rebrand.

Claire Giordano (Microsoft)

Parallel Queries in Postgres — Support for running parts of a query in parallel (a.k.a. parallel queries) didn’t land in Postgres with a single big thump, so the feature is easily overlooked. Elizabeth gives us a quick primer.

Elizabeth Christensen

A Gentle Introduction to Window Functions — A good, tight introduction focused on the essentials.

Radim Marek

Crunchy Bridge Adds Iceberg to Postgres — Crunchy Data has extended its Crunchy Bridge for Analytics platform with support for querying Iceberg tables, complete with full query pushdown and powerful write-through caching. (Iceberg is a table format specifically for large analytic datasets.)

Marco Slot (Crunchy Data)

ETL Helper 1.0: Python Library for Database to Database Transfers — One for the Pythonistas. Works with Postgres, SQLite, SQL Server and Oracle, and we love that it comes from the British Geological Survey.

British Geological Survey