Re: [HACKERS] possible de-optimization of multi-column index plans in 8.3

2007-03-12 Thread Tom Lane
Josh Berkus writes: > One of the Sun benchmarking guys ran across this issue, using a fairly > recent (within the last 4 weeks) 8.3 snapshot. It appears to me that the > 8.3 planner is unable to tell that, if the value for the first column of > an index scan is a constant, the second column do

[HACKERS] possible de-optimization of multi-column index plans in 8.3

2007-03-12 Thread Josh Berkus
All, One of the Sun benchmarking guys ran across this issue, using a fairly recent (within the last 4 weeks) 8.3 snapshot. It appears to me that the 8.3 planner is unable to tell that, if the value for the first column of an index scan is a constant, the second column doesn't need to be sorted