Collations are a wonderful feature. They solve problems way beyond case-insensitive search: ignoring accents and "numeric" sorting ('10' > '2') are just two more examples. However, they do have a performance impact as shown by this micro-benchmark: https://t.co/UOcEoQA38H
2
7
23
Replies
As sort-based indexes (such as B-Tree) also use collations to establish their row order, the speed of the collation affects the index build time, but not so much the search time as the number of comparisons for a search is very limited.
1
0
0
If you are not sure what collations are about, please read the entire series by Christophe Pettus: “Gentlemen, this is a 🏈”: Glyphs, Encodings, Collations, and Locales https://t.co/JDJ2Vm0hUs Speaking in Tongues: PostgreSQL and Character Encodings https://t.co/aLHuWPPM68
1
0
3
Farm to TABLE: Local(e) Providers https://t.co/0HGYKYWrYC The Doom That Came To PostgreSQL: When Collations Change https://t.co/GmGHx3zwES
0
0
1
@SQLPerfTips @MarkusWinand Many years ago I tested TPC and found several performance killer, including the Chinese collations, Decimal data types.
0
0
0