Re: Gsoc2012 idea, tablesample

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Qi Huang <huangqiyx(at)hotmail(dot)com>
Cc: strk(at)keybit(dot)net, robertmhaas(at)gmail(dot)com, 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, fgp(at)phlo(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Gsoc2012 idea, tablesample
Date: 2012-05-14 11:57:15
Message-ID: 20120514115715.GJ1267@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Qi Huang (huangqiyx(at)hotmail(dot)com) wrote:
> 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.

That sounds like the right first steps to me. Reviewing this
discussion, it was my thought to create a new node, ala seqscan, which
implemented analyze's algorithm for scanning the table. The eventual
idea being that analyze would actually use it in the future. There was
mention up-thread about just calling the analyze code. Personally, I'd
rather we make analyze more SQL like (once we have this functionality
implemented) than make things which are supposed to be SQL call out into
analyze bits.

Thoughts? Other opinions?

Thanks,

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message chinnaobi 2012-05-14 12:18:34 hot standby PSQL 9.1 Windows 2008 Servers
Previous Message Andres Freund 2012-05-14 09:32:35 Re: WalSndWakeup() and synchronous_commit=off