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
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
Hey guys,
I am taking my chances of posting a devel doubt on this list (couldn't find
any other relevant list). I think I have spent too much time on
this and need a fresh pair of eyes to look in it..
So this is my situation:
1. I have added a new field to RangeTblEntry (bool tablesample).
2. I
Seems like a better solution. I can finish the patch pretty soon. I need
to contact the original author, who has disappeared, but I'll send it over
to you.
Sounds good. I wondered where he'd gone to.
Still here :-)
Just got swamped with too much work that the tablesample
patch got paged