Re: CLONE TABLE DATA TO - Mailing list pgsql-hackers

From Marc Mamin
Subject Re: CLONE TABLE DATA TO
Date
Msg-id C4DAC901169B624F933534A26ED7DF310861B2C3@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Re: CLONE TABLE DATA TO  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
This would be great, but I can't C  :-(

Marc

> -----Original Message-----
> From: Robert Haas [mailto:robertmhaas@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.Mamin@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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: CLONE TABLE DATA TO
Next
From: Simon Riggs
Date:
Subject: Disabled features on Hot Standby