PostgreSQL Notes - Daniel Vérité

When communicating UUID-v7 values to third parties, the creation dates inside them are leaked.

the psql client version 18 comes with pipelining, which can speed up client-server communication.

With three locale providers (libc, icu and builtin), a PostgreSQL instance has potentially three different versions of Unicode at the same time.

In May 2024, the IETF standard on UUIDs (Universally Unique IDentifiers) has been updated with RFC 9562, finally officializing the UUID Version 7.

Among the novelties of PostgreSQL 17, recently released in beta, there’s a built-in UTF-8 locale and collation with binary string comparisons.

In this post, let’s see how to control psql from outside with the coproc functionality in bash.

In a previous post, I mentioned that Postgres databases often have text indexes sorted linguistically rather than bytewise, which is why they need to be reindexed on libc or ICU upgrades.

Let's implement a search function that can look for something into all columns of all tables.

A versioning bug in the ICU 73 release might affect people that use ICU collations with Postgres.

How to use alternative date and time types to use non-gregorian calendars with ICU.