Re: Gsoc2012 Idea --- Social Network database schema - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Gsoc2012 Idea --- Social Network database schema
Date
Msg-id CA+TgmobRSD=3rR4pTWUi1yUoEB8h11YtDV2uedbLcP4sXvQ0cA@mail.gmail.com
Whole thread Raw
In response to Re: Gsoc2012 Idea --- Social Network database schema  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-hackers
On Sun, Mar 25, 2012 at 6:11 AM, Marc Mamin <M.Mamin@intershop.de> wrote:
> Hello,
>
> Here is something we'd like to have:
>
> http://archives.postgresql.org/pgsql-hackers/2012-01/msg00650.php
>
> As we are quite busy and this issue hasn't a high priority, we haven't
> followed it until now :-(
>
> I'm only a Postgres user, not a hacker, so I don't have the knowledge to
> help on this nor to evaluate if this is might be a good Gssoc project.
>
> Just an idea for the case you are looking for another topic.

Good idea.  If anyone want so pursue it, I'd strongly suggest building
it as a contrib module rather than dedicated syntax, because I'm not
sure there'd be any consensus on adding syntax for it to core.

Actually, though, I wonder how much faster it would be than CREATE
TABLE AS?  Block-level copy should be faster than tuple-level copy,
but I'm not sure whether it would be a lot faster or only slightly
faster.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PATCH] Never convert n_distinct < 2 values to a ratio when computing stats
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Never convert n_distinct < 2 values to a ratio when computing stats