Re: Detach/attach table and index data files from one cluster to another - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Detach/attach table and index data files from one cluster to another
Date
Msg-id 20130412181511.GL4361@tamriel.snowman.net
Whole thread Raw
In response to Re: Detach/attach table and index data files from one cluster to another  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Detach/attach table and index data files from one cluster to another
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Well, it wouldn't be that hard to replace XIDs with FrozenXID or
> InvalidXID as appropriate, if you had access to the source database's
> clog while you did the copying.  It just wouldn't be very fast.

If you're doing that in a streaming method, it strikes me that it'd be
plenty fast.

> I suppose it would still be faster than a COPY transfer, but I'm not
> sure it'd be enough faster to justify the work and the additional
> portability hits you'd be taking.

The big win here over a binary COPY is pulling through the indexes as-is
as well- without having to rebuild them.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: (auto)vacuum truncate exclusive lock
Next
From: Tom Lane
Date:
Subject: Re: Detach/attach table and index data files from one cluster to another