Re: [HACKERS] MIN() performance regression 8.0 -> 8.1

2005-12-04 Thread Tom Lane
Paul Lindner <[EMAIL PROTECTED]> writes: > I believe I've found a performance regression between 8.0 and 8.1 for > some cases. For some queries it appears that the old MIN() ran much > faster than the new optimized MIN(). When you are complaining about planner mistakes, showing EXPLAIN rather tha

[HACKERS] MIN() performance regression 8.0 -> 8.1

2005-12-04 Thread Paul Lindner
Hi, I believe I've found a performance regression between 8.0 and 8.1 for some cases. For some queries it appears that the old MIN() ran much faster than the new optimized MIN(). The following set of query plans illustrates the problem. (schema names changed to protect the innocent...) Basical