On Mon, 2005-08-29 at 14:58 -0700, Varun Kacholia wrote:
> > I assume you realise that Bernoulli sampling is currently possibly using
> > the random() function and setseed() ?
> Yes, select * from table where random() < x, does the job.
>
> > I can't see why TABLESAMPLE effects a sequential scan
> I assume you realise that Bernoulli sampling is currently possibly using
> the random() function and setseed() ?
Yes, select * from table where random() < x, does the job.
> I can't see why TABLESAMPLE effects a sequential scan *only*, in all
> cases. I agree that there seems little point in s
On Sat, 2005-08-27 at 17:00 -0700, Varun Kacholia wrote:
> Hi everybody,
> I would like to add query sampling support to postgresql (atleast as a part
> of
> my project, if someone feels strongly against checking it in the main
> branch).
> I have been going over the code and I do see a lot of
Hi everybody,
I would like to add query sampling support to postgresql (atleast as a part of
my project, if someone feels strongly against checking it in the main branch).
I have been going over the code and I do see a lot of sampling stuff
in backend/commands/analyze.c. However, I plan to add s
