Re: ANALYZE sampling is too good - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ANALYZE sampling is too good
Date
Msg-id 30686.1386633155@sss.pgh.pa.us
Whole thread Raw
In response to Re: ANALYZE sampling is too good  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
Heikki Linnakangas <hlinnakangas@vmware.com> writes:
> Maybe. Or maybe the heuristic read ahead isn't significant/helpful, when you're prefetching with posix_fadvise
anyway.

Yeah.  If we're not reading consecutive blocks, readahead is unlikely
to do anything anyhow.

Claudio's comments do suggest that it might be a bad idea to issue a
posix_fadvise when the next block to be examined *is* adjacent to the
current one, though.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Claudio Freire
Date:
Subject: Re: ANALYZE sampling is too good
Next
From: Tom Lane
Date:
Subject: Re: [RFC] Shouldn't we remove annoying FATAL messages from server log?