Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer bug in subselect/view - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Optimizer bug in subselect/view
Date
Msg-id 5014.1047569779@sss.pgh.pa.us
Whole thread Raw
In response to Optimizer bug in subselect/view  (Andrew Koshelev <andrew@sgg.ru>)
List pgsql-bugs
Tree view 
Andrew Koshelev <andrew@sgg.ru> writes:
> As you can see, optimizer in earlier version of PostgreSQL skips
> unneeded data, but latest version doesn't.

CVS tip works the way you want it to.  The behavior in 7.3.* is an
unfortunate side-effect of a quick-and-dirty bug fix.  The less dirty
way to fix it is in CVS tip but was deemed too risky to backpatch
into 7.3.*.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: create table permissions bug for 7.3.2
Next
From: Laurent FAILLIE
Date:
Subject: Re: Solution for bug #899