Besides, I saw the Gsoc site editing has been closed. Should I just submit through this mailing list with attachment?
Best Regards and ThanksHuang Qi VictorComputer Science of National University of Singapore > Date: Tue, 17 Apr 2012 09:16:29 +0300 > From: [email protected] > To: [email protected] > CC: [email protected]; [email protected]; [email protected]; > [email protected]; [email protected]; [email protected]; > [email protected]; [email protected] > Subject: [HACKERS] Gsoc2012 idea, tablesample > > On 24.03.2012 22:12, Joshua Berkus wrote: > > Qi, > > > > Yeah, I can see that. That's a sign that you had a good idea for a > > project, actually: your idea is interesting enough that people want to > > debate it. Make a proposal on Monday and our potential mentors will help > > you refine the idea. > > Yep. The discussion withered, so let me try to summarize: > > 1. We probably don't want the SQL syntax to be added to the grammar. > This should be written as an extension, using custom functions as the > API, instead of extra SQL syntax. > > 2. It's not very useful if it's just a dummy replacement for "WHERE > random() < ?". It has to be more advanced than that. Quality of the > sample is important, as is performance. There was also an interesting > idea of on implementing monetary unit sampling. > > I think this would be a useful project if those two points are taken > care of. > > Another idea that Robert Haas suggested was to add support doing a TID > scan for a query like "WHERE ctid< '(501,1)'". That's not enough work > for GSoC project on its own, but could certainly be a part of it. > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > > -- > Sent via pgsql-hackers mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers
