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.
--
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general