josepheconway

3 ms·

1. 1.▲
   by josepheconway 3y ago

   I have not tried to measure the performance impact, although I have no doubt that it exists and is significant. Basically it boils down to the difference in performance of doing memcmp() versus strcoll() for every comparison needed to sort
2. 2.▲
   PostgreSQL 17 gains built-in collation(postgresql.org)

   39 points by josepheconway 3y ago|10 comments
3. 3.▲
   by josepheconway 3y ago

   Built-in collation provider committed to PostgreSQL 17 (still in development) complements of Jeff Davis. This is a huge step forward for PostgreSQL users! If you don't understand why, you should research it.