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

From Greg Stark
Subject Re: ANALYZE sampling is too good
Date
Msg-id CAM-w4HN__RLfYhvtyBGDYFnmRZsyQXey4kZE-NUHggnC4NT0BA@mail.gmail.com
Whole thread Raw
In response to Re: ANALYZE sampling is too good  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: ANALYZE sampling is too good
List pgsql-hackers
<p dir="ltr"><br /> I think we're all wet here. I don't see any bias towards larger or smaller rows. Larger tied will
beon a larger number of pages but there will be fewer of them on any one page. The average effect should be the same.<p
dir="ltr">Smallervalues might have a higher variance with block based sampling than larger values. But that actually
*is*the kind of thing that Simon's approach of just compensating with later samples can deal with.<br /><br /><p
dir="ltr">--<br /> greg 

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: preserving forensic information when we freeze
Next
From: Martijn van Oosterhout
Date:
Subject: Re: ANALYZE sampling is too good