Re: Gsoc2012 idea, tablesample - Mailing list pgsql-hackers

From Qi Huang
Subject Re: Gsoc2012 idea, tablesample
Date
Msg-id BAY159-W5429F8EC1530626002847FA31A0@phx.gbl
Whole thread Raw
In response to Re: Gsoc2012 idea, tablesample  (Sandro Santilli <strk@keybit.net>)
Responses Re: Gsoc2012 idea, tablesample
List pgsql-hackers
> Date: Fri, 11 May 2012 15:59:51 +0200
> From: strk@keybit.net
> To: robertmhaas@gmail.com
> CC: Kevin.Grittner@wicourts.gov; ants@cybertec.at; josh@agliodbs.com; andres@anarazel.de; alvherre@commandprompt.com; heikki.linnakangas@enterprisedb.com; cbbrowne@gmail.com; neil.conway@gmail.com; daniel@heroku.com; huangqiyx@hotmail.com; fgp@phlo.org; pgsql-hackers@postgresql.org; sfrost@snowman.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.Grittner@wicourts.gov> wrote:
> > > Ants Aasma <ants@cybertec.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 Thanks
Huang Qi Victor
Computer Science of National University of Singapore



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [BUG] Checkpointer on hot standby runs without looking checkpoint_segments
Next
From: Prakash Itnal
Date:
Subject: ERROR: catalog is missing 2 attribute(s) for relid 16584