Re: Optimizer bug in subselect/view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Koshelev <andrew(at)sgg(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Optimizer bug in subselect/view
Date: 2003-03-13 15:36:19
Message-ID: 5014.1047569779@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Andrew Koshelev <andrew(at)sgg(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Laurent FAILLIE 2003-03-13 16:04:14 Re: Solution for bug #899
Previous Message Tom Lane 2003-03-13 15:15:37 Re: create table permissions bug for 7.3.2