Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] PG-10 + ICU and abbreviated keys - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: [GENERAL] PG-10 + ICU and abbreviated keys
Date
Msg-id VisenaEmail.57.761d918d5ec1bd06.15fb7243e9d@tc7-visena
Whole thread Raw
In response to Re: [GENERAL] PG-10 + ICU and abbreviated keys  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: [GENERAL] PG-10 + ICU and abbreviated keys
List pgsql-general
Tree view
På mandag 13. november 2017 kl. 21:46:08, skrev Peter Geoghegan <pg@bowt.ie>:
On Mon, Nov 13, 2017 at 12:40 PM, Peter Geoghegan <pg@bowt.ie> wrote:
>> Do I have to explicitly specify collation when using ORDER by on that column for index and abbreviated keys to be used?
>
> Only if you didn't define the column with a per-column collation initially.

BTW, if you specifically want to quickly verify whether or not
abbreviated keys were used, you can do that by setting "trace_sort =
on", and possibly setting "client_min_messages = LOG", too.

There should be quite a bit of debug output from that that
specifically mentions abbreviated keys.
 
Thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 

pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: [GENERAL] PG-10 + ICU and abbreviated keys
Next
From: Peter Geoghegan
Date:
Subject: Re: [GENERAL] PG-10 + ICU and abbreviated keys