Re: Multi-pass planner - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Multi-pass planner
Date
Msg-id CAMkU=1wnmcZOX3B9Qy79qtVvAr9hx=VvxVZOB-B0C82B_ZPdng@mail.gmail.com
Whole thread Raw
In response to Re: Multi-pass planner  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Multi-pass planner
List pgsql-hackers
<div dir="ltr">On Fri, Apr 19, 2013 at 2:24 PM, Claudio Freire <span dir="ltr"><<a
href="mailto:klaussfreire@gmail.com"target="_blank">klaussfreire@gmail.com</a>></span> wrote:<br /><div
class="gmail_extra"><divclass="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px
#cccsolid;padding-left:1ex"><div class="im"><br /></div>Especially if there's some locality of occurrence, since
analyze<br/> samples pages, not rows.<br /></blockquote></div><br /></div><div class="gmail_extra" style="style">But it
doesn'ttake all rows in each sampled page.  It generally takes about one row per page, specifically to avoid the
problemyou indicate. Maybe it is possible to trick it into taking too many (for example, if most pages are completely
empty),but I haven't experienced that as being a problem.</div><div class="gmail_extra" style="style"><br /></div><div
class="gmail_extra"style="style">Cheers,</div><div class="gmail_extra" style="style"><br /></div><div
class="gmail_extra"style="style">Jeff</div></div> 

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Multi-pass planner
Next
From: Claudio Freire
Date:
Subject: Re: Multi-pass planner