This site is about a previous instance of this event. For the current event, please see the updated site.

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.


The following slides have been made available for this session:


Tobias Bussmann