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.66.5e57741f5f43c59.15fb7ca0ed3@tc7-visena
Whole thread Raw
In response to Re: [GENERAL] PG-10 + ICU and abbreviated keys  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-general
Tree view
På tirsdag 14. november 2017 kl. 00:44:11, skrev Peter Geoghegan <pg@bowt.ie>:
On Mon, Nov 13, 2017 at 2:05 PM, Andreas Joseph Krogh
<andreas@visena.com> wrote:
> When sorting on text, we're usually doing so using an multi-column index, like for instance "CREATE INDEX xxx ON my_table (lower(name) ASC, created ASC)". Will abbreviated keys help here?

Yes, they'll help with that, even though the leading column might be
low cardinality.
 
Nice to know, thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [GENERAL] PG-10 + ICU and abbreviated keys
Next
From: Jeremy Schneider
Date:
Subject: Re: [GENERAL] archive_command not being executed