Conference Schedule - PGConf.EU 2022

Collations in PostgreSQL: The good, the bad and the ugly.

Date: 2022-10-28
Time: 09:30–10:20
Room: Berlin 1
Level: Intermediate

Locales, Collations and Encodings are often given little attention by database users.

Over the recent years, PostgreSQL's possibilities in this area have grown a lot, especially with the inclusion of the ICU-library. This makes it possible to support a wide range of special requirements directly in your database.

But even for simple applications, attention should be paid to the topic, because there are a number of pitfalls. These can not only impair performance, but even lead to serious data corruption that can easily be noticed too late.

In this presentation, we will explore the features available and raise awareness of the things to watch out for. In particular, we will look at the improvements that have been made recently, both in terms of features and safeguards, and look ahead to future ideas.


Tobias Bussmann