#​500 — April 5, 2023

Web Version

Together with  EDB

Postgres Weekly

PL/Rust 1.0: Write Postgres Functions in Rust — This is particularly exciting as PL/Rust functions are not interpreted in the way PL/pgSQL or PL/Python functions are, but are compiled to native machine code. This gives extension-style levels of performance in a more dynamic form. I suspect we’ll see a lot of progress and use cases for this soon. More info here.

Technology Concepts and Design, Inc.

How to Get Up to Five 9s Uptime with Next Generation Postgres — Near-zero downtime is mission-critical for so many industries. Learn how to reduce risk and improve productivity and customer satisfaction with multi-master replication and data distribution via advanced conflict management and data-loss protection.

EDB sponsor

SQL:2023 is Done, But What's New? — The latest version of the SQL standard is now with the so called ‘ISO gods’ and will be published in due course. No database follows SQL standards precisely but it can be useful to see what’s new as features in the standard tend to filter into Postgres over time (or vice versa, as seen with a JSON type just being added to the spec).

Peter Eisentraut

Google Offers Version of AlloyDB That Runs 'Anywhere' — Google first unveiled AlloyDB for PostgreSQL a year ago, as a managed Postgres-compatible service vaguely similar in ethos to Amazon Aurora but from Google. They now have a preview of AlloyDB Omni, a downloadable edition of AlloyDB designed to run off of Google’s cloud.

Google Cloud Blog

The Ultimate Guide to Citus Con: An Event for PostgresCitus Con is a free, online Postgres event being put on by the Postgres team at Microsoft Azure across April 18-19. In this post, you can learn more about everything that’s on offer, or maybe let Claire ▶️ convince you in video form?

Claire Giordano


Hydra: Introducing Updates and Deletes on Columnar PostgresHydra is a Postgres-powered data warehouse / OLAP system billed as an “open source Snowflake alternative.” They’ve now released the latest part of the puzzle: supporting updates and deletes on otherwise immutable and append only columnar storage, and this post explains how. GitHub repo.

Jonathan Dance (Hydra)

Row Locks in Postgres — Laurenz quickly covers the four different types of row lock (as opposed to table lock) in Postgres, why you’d pick certain ones, and how they work under the hood. All very accessible and useful stuff to know.

Laurenz Albe

Representing Time Ranges without Overlapping — Guaranteeing non-overlapping time ranges (for e.g. hotel bookings) is not easy because of race conditions. Postgres’s exclusion constraints and range types can help though.

Tobias Petry

A Special Illustrated Postgres Migration Story

Crunchy Bridge sponsor

Assigning Blame for Postgres Errors — Error messages in Postgres’s logs may not always be the fault of the database alone. Robert looks at cases where user error or operating system issues might come into play.

Robert Haas

Easy Mongo from Your Postgres — An exploration of the benefits of pairing MongoDB and Postgres by way of the MongoDB foreign data wrapper (which is now supported by all new Crunchy Bridge deployments).

Christopher Winslett (Crunchy Data)

Go Integration Tests with Postgres — A look at a few ways to use Postgres in testing scenarios, each with their own pros and cons.

Egon Elbre

Aurora Database Authorization using Role-Based Access Control
Pinyani and Lonappan (AWS)