From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PG-10 + ICU and abbreviated keys |
Date: | 2017-11-13 23:50:04 |
Message-ID: | VisenaEmail.66.5e57741f5f43c59.15fb7ca0ed3@tc7-visena |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
På tirsdag 14. november 2017 kl. 00:44:11, skrev Peter Geoghegan <pg(at)bowt(dot)ie
<mailto:pg(at)bowt(dot)ie>>:
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.
Nice to know, thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Schneider | 2017-11-13 23:56:36 | Re: archive_command not being executed |
Previous Message | Peter Geoghegan | 2017-11-13 23:44:11 | Re: PG-10 + ICU and abbreviated keys |