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
Поделиться в:
Доступные форматы для скачивания:
Скачать видео mp4
Информация по загрузке:
Скачать аудио mp3
Похожие видео
array(10) {
[0]=>
object(stdClass)#5779 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "xlDIqTW079s"
["related_video_title"]=>
string(85) "New features of the Odyssey connection pooler | Citus Con: An Event for Postgres 2022"
["posted_time"]=>
string(21) "3 года назад"
["channelName"]=>
string(19) "Microsoft Developer"
}
[1]=>
object(stdClass)#5752 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "t8rAOgDdH1U"
["related_video_title"]=>
string(94) "Optimizing Postgres for write heavy workloads ft. Checkpoint and WAL configs | Citus Con 2023"
["posted_time"]=>
string(21) "2 года назад"
["channelName"]=>
string(19) "Microsoft Developer"
}
[2]=>
object(stdClass)#5777 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "SpfIwlAYaKk"
["related_video_title"]=>
string(33) "PostgreSQL Tutorial for Beginners"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(16) "freeCodeCamp.org"
}
[3]=>
object(stdClass)#5784 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "rADPOp4Ewm4"
["related_video_title"]=>
string(85) "What Microsoft is Building for Postgres in 2025 | POSETTE: An Event for Postgres 2025"
["posted_time"]=>
string(22) "12 дней назад"
["channelName"]=>
string(19) "Microsoft Developer"
}
[4]=>
object(stdClass)#5763 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "clrtT_4WBAw"
["related_video_title"]=>
string(41) "PostgreSQL Indexing : How, why, and when."
["posted_time"]=>
string(19) "6 лет назад"
["channelName"]=>
string(8) "PyCon AU"
}
[5]=>
object(stdClass)#5781 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "BJIohxOyHLQ"
["related_video_title"]=>
string(171) "Не пора ли снимать деньги со вкладов? / Блокировки и цифровой суверенитет || Дмитрий Потапенко*"
["posted_time"]=>
string(24) "13 часов назад"
["channelName"]=>
string(33) "Дмитрий ПОТАПЕНКО"
}
[6]=>
object(stdClass)#5776 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "OIZAbldPBcI"
["related_video_title"]=>
string(42) "Долгожданный МИР. Или..."
["posted_time"]=>
string(23) "6 часов назад"
["channelName"]=>
string(27) "Анатолий Шарий"
}
[7]=>
object(stdClass)#5786 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "pFKwmEdwZZQ"
["related_video_title"]=>
string(78) "CI/CD — Простым языком на понятном примере"
["posted_time"]=>
string(27) "9 месяцев назад"
["channelName"]=>
string(25) "Артём Шумейко"
}
[8]=>
object(stdClass)#5762 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "blWdjRUPP6E"
["related_video_title"]=>
string(72) "Разведчик о том, как использовать людей"
["posted_time"]=>
string(25) "3 недели назад"
["channelName"]=>
string(18) "Коллектив"
}
[9]=>
object(stdClass)#5780 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "i-FFVM4cIXQ"
["related_video_title"]=>
string(138) "База по Базам Данных - Storage (Индексы, Paging, LSM, B+-Tree, R-Tree) | Влад Тен Систем Дизайн"
["posted_time"]=>
string(22) "10 дней назад"
["channelName"]=>
string(15) "Влад Тен"
}
}
