Localization on PostgreSQL | Citus Con: An Event for Postgres 2022

Описание: Video of a talk on the topic of Localization in Postgres presented by Keisuke Takahashi in the APAC livestream of Citus Con: An Event for Postgres. Abstract: Do you know how many languages on this planet? How about top 10 languages used on the internet? Is English the language that has the largest population as their mother tongue? From the perspective of Diversity and Inclusion, we share the common sense about the importance of multi-language support. As other major relational database management systems do so, the Postgres database also provides localization features, specifically locale support, collation support, and character set support. Let's learn them and put PostgreSQL to use for empowering every person and organization on the planet to achieve more.

Keisuke Takahashi is a Cloud Solution Architect in Data & Analytics at Microsoft. Keisuke has been with Microsoft since 2021. Keisuke has been with Open Source Software for 24 years and experienced using PostgreSQL in his projects.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 01:51 Introduction to localization in Postgres
⏩ 03:24 Character sets: supported sets, defaults, & setting
⏩ 05:42 Locale basics in Postgres
⏩ 07:09 Collation basics in Postgres
⏩ 10:30 Sorting experiments on Hyperscale (Citus)
⏩ 23:25 Cost comparisons
⏩ 25:46 Conclusions
⏩ 27:46 Q&A with Keisuke & Aaron

✅ Learn more:
Watch more Citus Con talks: https://aka.ms/cituscon-playlist

📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon

📌 Let’s connect:
Twitter – @CitusCon,   / cituscon  

#CitusCon #PostgreSQL #Database