Collations: Introduction, Features, Problems - Peter Eisentraut
The sort order of text in an SQL database is influenced by so-called collations. These usually work behind the scenes, but they offer a number of interesting customization possibilities, while also being a potential source of operational problems and user confusion. In this presentation, I want to start by explaining how modern collations work and what the role of Unicode is. Then we'll discuss what variants and customization options exist, such as language-specific collation and case insensitivity, and how PostgreSQL implements those. Here we can also take a look ahead at relevant development projects for future PostgreSQL versions. Finally, we'll look at how collations affect the management of databases and particularly upgrades. There are some traps here that could cause index corruption or data loss.
Видео Collations: Introduction, Features, Problems - Peter Eisentraut канала ITPUG Italian PostgreSQL Users Group
Видео Collations: Introduction, Features, Problems - Peter Eisentraut канала ITPUG Italian PostgreSQL Users Group
Показать
Комментарии отсутствуют
Информация о видео
12 июля 2019 г. 18:04:47
00:42:23
Другие видео канала
![Magnus Hagander - Keynote Speaker al PGDay.IT 2019](https://i.ytimg.com/vi/7rCGoLKLdTM/default.jpg)
![Luca Veronese - Speaker al PGDay.IT 2019](https://i.ytimg.com/vi/2bH2MGJh6FA/default.jpg)
![Tracciare i cambiamenti in PostgreSQL con la replica logica, fluentd e ClickHouse - Leonardo Cecchi](https://i.ytimg.com/vi/GEWOZKYSFvQ/default.jpg)
![Jsonpath - a query language for json - Oleg Bartunov](https://i.ytimg.com/vi/LOXmgM8Vtqc/default.jpg)
![Oleg Bartunov - Speaker al PGDay.IT 2019](https://i.ytimg.com/vi/aQkS6PnWL0I/default.jpg)
![Privacy and security: PostgreSQL to the rescue - Denis Gasparin](https://i.ytimg.com/vi/3o65ro89kYM/default.jpg)
![PostgreSQL at low-level: stay curious! - Dmitrii Dolgov](https://i.ytimg.com/vi/sdLGj9dwGYY/default.jpg)
![PGDay.IT 2017 - Patroni: PostgreSQL HA nel cloud - Lucio Grenzi](https://i.ytimg.com/vi/grPmlcq4lFQ/default.jpg)
![Paolo Melchiorre - Speaker al PGDay.IT 2019](https://i.ytimg.com/vi/BpiE-zc56xw/default.jpg)
![Denis Gasparin - Speaker al PGDay.IT 2019](https://i.ytimg.com/vi/KbGcRsLipBs/default.jpg)
![PGDay.IT 2017](https://i.ytimg.com/vi/3Xp5m5JHMU8/default.jpg)
![PGDay.IT](https://i.ytimg.com/vi/jCz0d0NObhk/default.jpg)
![The best of PGDay.IT 2018](https://i.ytimg.com/vi/mhp5CSV9O2I/default.jpg)
![PGDay.IT 2017 - Disaster Recovery: una serie di sfortunati eventi - Cecchi, Calacoci, Canovai](https://i.ytimg.com/vi/hVSs2IxCluo/default.jpg)
![PGDay.IT 2018 - Visualizza i tuoi dati con Superset - Riccardo Magliocchetti](https://i.ytimg.com/vi/sMVTxNtCOAU/default.jpg)
![PGDay.IT 2017 - (Ri)scrivere l'SQL per ottenere le massime prestazioni - Luca Veronese](https://i.ytimg.com/vi/FKHRQZJWWgU/default.jpg)
![PGDay.IT 2017 - PostgreSQL Realtime Queries at Scale - Wolfram Hempel](https://i.ytimg.com/vi/nC17nCvepX4/default.jpg)
![PGDay.IT 2018 - Replica logica in PostgreSQL: il futuro è adesso - Marco Nenciarini](https://i.ytimg.com/vi/B6uzzaaGatk/default.jpg)
![How to use logical decoding to build a custom replication system - Ronan Dunklau](https://i.ytimg.com/vi/5mn29sJDHU4/default.jpg)
![PGDay.IT 2017 - PostgreSQL and the Raspberry Pi - Rubens Souza](https://i.ytimg.com/vi/E90WrohcFU0/default.jpg)
![Fabio Benedetti - Speaker al PGDay.IT 2019](https://i.ytimg.com/vi/vzNMHVf4yZg/default.jpg)