On Tue, Nov 21, 2017 at 12:19 AM, Boris Sagadin <sagadin@gmail.com> wrote:
> No string is over 200 chars. By function name I assumed the get_next_seq is
> pgsql related, but now I've learned it's glibc. Sorting in shell with same
> locale is indeed very slow, I used just 1% of data in that column and it
> finishes sorting in a few minutes. Thanks, I'll check with glibc.
If you upgrade to Postgres 10, you could then use ICU collations on
text columns, where CREATE INDEX can be expected to perform
significantly better:
https://blog.anayrat.info/en/2017/11/19/postgresql-10--icu--abbreviated-keys/
--
Peter Geoghegan