On Thu, Dec 3, 2009 at 10:45 AM, aftab khan <[email protected]> wrote: > This is not exactly the same what I posted yesterday, What I have posted > today also include EXPLAIN ANALYZE OUTPUT .
[ adding the list back to the CC line ] It looks like you have a problem very similar to one Laurence Laborde was complaining about recently on pgsql-performance. My discussion of the problem is here: http://archives.postgresql.org/pgsql-performance/2009-12/msg00022.php In your case, the reason why the estimates are off is because of the lack of multi-column statistics, rather than because of the choice of operator, but the issues are similar. ...Robert -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
