Localization in PostgreSQL - Implementing Multi-Language Support

Explore localization features in PostgreSQL through this conference talk presented by Keisuke Takahashi at Citus Con: An Event for Postgres 2022. Gain insights into character sets, locale support, and collation in Postgres, and understand their importance for multi-language database management. Learn about sorting experiments on Hyperscale (Citus), compare costs, and discover how to leverage PostgreSQL's localization capabilities to support diverse languages and empower global users. The talk concludes with a Q&A session, providing additional insights into localization practices in PostgreSQL.

Syllabus

Introduction.
Introduction to localization in Postgres.
Character sets: supported sets, defaults, & setting.
Locale basics in Postgres.
Collation basics in Postgres.
Sorting experiments on Hyperscale (Citus).
Cost comparisons.
Conclusions.
Q&A with Keisuke & Aaron.