Published On Mar 30, 2023
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
In episode 61 of “5mins of Postgres” we’re talking about collations in Postgres. We’ll specifically take a look at glibc and ICU collations, and problems that can arise when using different operating system releases.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
Did Postgres Lose My Data? - by Jeremy Schneider
https://ardentperf.com/2023/03/26/did...
Jeremy Schneider on Twitter
/ jer_s
ICU collations on postgresql.org
https://www.postgresql.org/docs/curre...
glibc library
https://www.gnu.org/software/libc/
ICU library
https://icu.unicode.org/
Collation Changes Across Linux Versions - Jeremy Schneider’s GitHub repo
https://github.com/ardentperf/glibc-u...
How collation works - by Peter Eisentraut
http://peter.eisentraut.org/blog/2023...
Peter Eisentraut on Mastodon
https://mastodon.social/@petereisentraut
Manage collation changes in PostgreSQL on Amazon Aurora and Amazon RDS - by Jonathan Katz
https://aws.amazon.com/blogs/database...
Jonathan Katz on Twitter
/ jkatz05