Bug #4284 - Mailing list pgsql-hackers

From David Rowley
Subject Bug #4284
Date
Msg-id A0B29375B092437BAE089CF17DA0B05C@amd64
Whole thread Raw
Responses Re: Bug #4284
List pgsql-hackers
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I had an email today about an old bug that I reported back in July 2008.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"><a
href="http://archives.postgresql.org/pgsql-bugs/2008-07/msg00026.php">http://archives.postgresql.org/pgsql-bugs/2008-07/msg00026.php</a></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I didn’t receive any response at the time and I didn’t really follow it up.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">My report contained a full re-creation script to reproduce the problem and tonight I’m having the
sameproblem with CVS Head. To my untrained eye it looks like the planner is not properly pushing down the row count.
</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I know this is a busy time for all, but this seems to be distressing a few people. At the time I
didn’tfind anyway apart from disabling nested loops.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Would anyone gifted in the art of the query planner be able to look at this?</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">David.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font></div>

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: advance local xmin more aggressively
Next
From: Robert Haas
Date:
Subject: Re: Optimization rules for semi and anti joins