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.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company