Re: Gsoc2012 idea, tablesample

> Date: Fri, 11 May 2012 15:59:51 +0200
> From: strk(at)keybit(dot)net
> To: robertmhaas(at)gmail(dot)com
> CC: Kevin(dot)Grittner(at)wicourts(dot)gov; ants(at)cybertec(dot)at; josh(at)agliodbs(dot)com; andres(at)anarazel(dot)de; alvherre(at)commandprompt(dot)com; heikki(dot)linnakangas(at)enterprisedb(dot)com; cbbrowne(at)gmail(dot)com; neil(dot)conway(at)gmail(dot)com; daniel(at)heroku(dot)com; huangqiyx(at)hotmail(dot)com; fgp(at)phlo(dot)org; pgsql-hackers(at)postgresql(dot)org; sfrost(at)snowman(dot)net
> Subject: Re: [HACKERS] Gsoc2012 idea, tablesample
>
> On Thu, May 10, 2012 at 02:30:35PM -0400, Robert Haas wrote:
> > On Thu, May 10, 2012 at 2:07 PM, Kevin Grittner
> > <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> > > Ants Aasma <ants(at)cybertec(dot)at> wrote:
> > >> It seems to me that the simplest thing to do would be to lift the
> > >> sampling done in analyze.c (acquire_sample_rows) and use that to
> > >> implement the SYSTEM sampling method.
> > >
> > > Definitely. I thought we had all agreed on that ages ago.
> >
> > Right, and I don't think we should be considering any of this other
> > stuff until that basic thing is implemented and working.
>
> Agreed. That's what I'd love to see as well, for the GIS part.
>
> --strk;

Thanks, guys, for your hot discussion. I'll explore the ANALYZE command first and try make SYSTEM sampling work. Other parts, I'll look at them later.

Best Regards and ThanksHuang Qi VictorComputer Science of National University of Singapore