Re: Postgresql Sort cost Poor performance?

From: Christoph Berg <myon(at)debian(dot)org>
To: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql Sort cost Poor performance?
Date: 2019-04-01 10:54:35
Message-ID: 20190401105435.GD13726@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Re: Gavin Flower 2019-04-01 <3113f2f4-a4da-4862-8596-2e189398c988(at)archidevsys(dot)co(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mariel Cherkassky 2019-04-01 11:20:25 Re: trying to analyze deadlock
Previous Message Gavin Flower 2019-04-01 10:32:40 Re: Postgresql Sort cost Poor performance?