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
In response to Re: Multi-pass planner  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Multi-pass planner
List pgsql-hackers
On Fri, Apr 19, 2013 at 2:24 PM, Claudio Freire <klaussfreire@gmail.com> wrote:

Especially if there's some locality of occurrence, since analyze
samples pages, not rows.

But it doesn't take all rows in each sampled page.  It generally takes about one row per page, specifically to avoid the problem you 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.

Cheers,

Jeff

pgsql-hackers by date:

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