From: Christoph Berg <myon@debian.org>
To: Gavin Flower <GavinFlower@archidevsys.co.nz>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Postgresql Sort cost Poor performance?
Date: Mon, 1 Apr 2019 12:54:35 +0200
Message-ID: <20190401105435.GD13726@msg.df7cb.de> (raw)
In-Reply-To: <3113f2f4-a4da-4862-8596-2e189398c988@archidevsys.co.nz>
References: <1554111914781-0.post@n3.nabble.com>
<87d0m6uj5u.fsf@news-spur.riddles.org.uk>
<3113f2f4-a4da-4862-8596-2e189398c988@archidevsys.co.nz>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: myon@debian.org, GavinFlower@archidevsys.co.nz, pgsql-performance@lists.postgresql.org
Subject: Re: Postgresql Sort cost Poor performance?
In-Reply-To: <20190401105435.GD13726@msg.df7cb.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox