Re: PG-10 + ICU and abbreviated keys

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PG-10 + ICU and abbreviated keys
Date: 2017-11-13 23:44:11
Message-ID: CAH2-Wzmt3+aVDxH7c5AiJfm+-sKRyNBpktwbsqhPCGtHVOBDRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 13, 2017 at 2:05 PM, Andreas Joseph Krogh
<andreas(at)visena(dot)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.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2017-11-13 23:50:04 Re: PG-10 + ICU and abbreviated keys
Previous Message Hannes Erven 2017-11-13 22:08:16 "Cascading Logical Replication" from a physical replica