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


 

Reply via email to