As I've understood the docs those 2 limits should not take effect, because the performance is going down when adding
twoaggregated columns, but only when enable_material is on.<br /><br /><div class="gmail_quote">2011/5/25 Tom Lane
<spandir="ltr"><<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>></span><br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">Robert Haas
<<ahref="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>> writes:<br /> > On Tue, May 24, 2011 at 3:32
PM,Jasmin Dizdarevic<br /> > <<a href="mailto:jasmin.dizdarevic@gmail.com">jasmin.dizdarevic@gmail.com</a>>
wrote:<br/> >> enable_material = off<br /><br /> > Is there any chance you can reproduce this with a simpler
testcase<br /> > that doesn't involve quite so many joins?<br /><br /></div>I didn't stop to count, but are there
enoughthat join_collapse_limit<br /> or from_collapse_limit could be in play?<br /><br />
regards,tom lane<br /></blockquote></div><br />
