* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)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