Postgres Pro
Downloads
Home   >   mailing lists

Re: Sorting on longer key is faster ? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Sorting on longer key is faster ?
Date
Msg-id 12961.1121125670@sss.pgh.pa.us
Whole thread Raw
In response to Sorting on longer key is faster ?  ("jobapply" <jobapply@nextmail.ru>)
List pgsql-performance
Tree view 
"jobapply" <jobapply@nextmail.ru> writes:
> The 2 queries are almost same, but ORDER BY x||t is FASTER than ORDER BY x..
> How can that be possible?

Hmm, how long are the x values?  Is it possible many of them are
TOASTed?

            regards, tom lane

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: Sorting on longer key is faster ?
Next
From: John A Meinel
Date:
Subject: Re: Sorting on longer key is faster ?