On Fri, Jan 13, 2012 at 5:56 AM, Marc Mamin <M(dot)Mamin(at)intershop(dot)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.
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Marc Mamin||Date: 2012-01-13 13:25:22|
|Subject: Re: CLONE TABLE DATA TO <new_table>|
|Previous:||From: Greg Smith||Date: 2012-01-13 13:10:27|
|Subject: Re: pgbench post-connection command|