The following bug has been logged online:
Bug reference: 5294
Logged by: Allen Johnson
Email address: akjohnso...@gmail.com
PostgreSQL version: 8.4.2
Operating system: Red Hat ES 5.4
Description:Sorts on more than just the order-by clause
Details:
I've been po
> In practice, I really doubt this would make a measurable performance
> difference, since most row comparisons would arrive at a result before
> they got to the lowest-order columns.
>
> I think your gripe may actually have to do with a misestimate of the
> relative costs of hash- and sort-based g