Re: Postgresql Sort cost Poor performance? - Mailing list pgsql-performance

From Christoph Berg
Subject Re: Postgresql Sort cost Poor performance?
Date
Msg-id 20190401105435.GD13726@msg.df7cb.de
Whole thread Raw
In response to Re: Postgresql Sort cost Poor performance?  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-performance
Re: Gavin Flower 2019-04-01 <3113f2f4-a4da-4862-8596-2e189398c988@archidevsys.co.nz>
> Would it be possible to optionally enable the system to create a hidden
> system column for the text field to be sorted, the new column would be the
> original column preprocessed to sort correctly & efficiently.

That's the idea behind the strxfrm(3) optimization that ultimately got
disabled again for non-C locales because glibc fails to implement it
correctly.

Christoph



pgsql-performance by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Postgresql Sort cost Poor performance?
Next
From: Mariel Cherkassky
Date:
Subject: Re: trying to analyze deadlock