This would be great, but I can't C :-( Marc
> -----Original Message----- > From: Robert Haas [mailto:robertmh...@gmail.com] > Sent: Freitag, 13. Januar 2012 14:12 > To: Marc Mamin > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] CLONE TABLE DATA TO <new_table> > > On Fri, Jan 13, 2012 at 5:56 AM, Marc Mamin <m.ma...@intershop.de> > wrote: > > I wonder if it would be possible to have a fast table clone function > (data > > only) while copying the corresponding data files > > > > instead of using the "CREATE TABLE AS" way. > > > > pg_upgrade seems to have such a mechanisms, though it requires to > first stop > > the server... > > > > This would of course require to lock the complete table and ensure > that all > > latest changes are flushed to the plates. > > I think it would be possible to implement this. In fact, it could > probably be done as a contrib module. > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
