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

From Peter Geoghegan
Subject Re: ANALYZE sampling is too good
Date
Msg-id CAM3SWZRw93mAn1wBo0-5Aca-YD1-YqZskECZus+t5_E2gjvhog@mail.gmail.com
Whole thread Raw
In response to Re: ANALYZE sampling is too good  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Tue, Dec 10, 2013 at 10:34 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On 11 December 2013 01:27, Sergey E. Koposov <math@sai.msu.ru> wrote:
>> For what it's worth.
>>
>> I'll quote Chaudhuri et al. first line from the abstract about the block
>> sampling.
>> "Block-level sampling is far more efficient than true uniform-random
>> sampling over a large database, but prone to  significant errors if used to
>> create database statistics."
>
> This glosses over the point that both SQLServer and Oracle use this technique.

That seems like an unusual omission for Microsoft Research to have made.

I didn't read that paper, because undoubtedly it's all patented. But
before I figured that out, after finding it on Google randomly, I did
read the first couple of paragraphs, which more or less said "what
follows - the entire paper - is an explanation as to why it's okay
that we do block sampling".


-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: ANALYZE sampling is too good
Next
From: "Erikjan Rijkers"
Date:
Subject: invalid magic number in log segment