Handling Graphs with SQL/PGQ in Postgres 19 — Postgres 19 is adding support for SQL/PGQ, so you can declare a property graph over tables and pattern-match with Cypher-like  MATCH (a IS person)-[IS knows]->(b IS person) queries. It’s all handled by the query rewriter, so a graph pattern becomes a normal relational query.

Hans-Jürgen Schönig

95% Less Storage. 40% Faster Analytics. CERN on Postgres — CERN's Large Hadron Collider generates hundreds of GB of time-series data daily. In this live webinar, their engineers walk through how they modernized a legacy archiving stack with TimescaleDB. June 25, 9 AM ET.

Tiger Data (creators of TimescaleDB) sponsor

🔓 Why Postgres Lacks Transparent Data Encryption — Many other databases have it, but in Postgres you need to lean on third party services or the pg-tde extension. Why? Shaun digs into old discussions about the feature, and finds the biggest problem is defining what problem that TDE actually needs to solve.

Shaun Thomas

Helping the Planner Help You — When two columns are correlated, Postgres assumes they’re independent and the planner’s row estimates go badly wrong. A practical tour of CREATE STATISTICS and the better query plans it unlocks.

Valerie Parham-Thompson

Egress Problems and Where to Find Them — If your database is running in someone else’s datacenter, data egress and associated costs are important to control. Simeon shares tips on how to get the numbers down, along with some PlanetScale-specific advice.

Simeon Griggs (PlanetScale)

DeltaX (δx): Fast Time-Series Extension for Postgres — A new columnar storage extension for time-series data from Xata that uses only regular Postgres tables, so things like replication, crash recovery, backups, and pg_dump work as they usually would. Here’s how it works.

Xata

Streambed: Stream Postgres to Iceberg on S3 — Streams WAL via logical replication, writes Parquet to S3, and commits Iceberg metadata. You can then query with plain psql thanks to a built-in wire-protocol server.

viggy28

ingestr v1: Copy Data to and from Databases in One Command — A Go-powered tool to move data (with incremental append/merge support) between a myriad of sources and destinations (Postgres included) without writing code.

Bruin Data

Postgres at 30: A Chat With Its Creator — With Postgres turning 30 this year, here’s a treat: a wide-ranging interview with Mike Stonebraker, the man who started the Postgres project. He covers how Postgres came to be, where he thinks Google and Amazon get databases wrong, and what he’s building next.

The Peterman Pod