På tirsdag 14. november 2017 kl. 00:44:11, skrev Peter Geoghegan <[email protected] <mailto:[email protected]>>: On Mon, Nov 13, 2017 at 2:05 PM, Andreas Joseph Krogh <[email protected]> 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 [email protected] <mailto:[email protected]> www.visena.com <https://www.visena.com> <https://www.visena.com>
