[BUGS] BUG #5294: Sorts on more than just the order-by clause

2010-01-21 Thread Allen Johnson
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

Re: [BUGS] BUG #5294: Sorts on more than just the order-by clause

2010-01-21 Thread Allen Johnson
> 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