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 20130412184928.GM4361@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>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > The big win here over a binary COPY is pulling through the indexes as-is
> > as well- without having to rebuild them.

[... lots of reasons this is hard ...]

I agree that it's quite a bit more difficult, to the point that logical
replication which can be selective (eg: give me only table X + indexes)
might end up being the only answer, but otherwise this approach will
likely only be a modest improvement over binary COPY FREEZE- and there
only because we essentially end up skipping the type validation (which
we could just provide as an option, similar to COPY FREEZE...).
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [sepgsql 2/3] Add db_schema:search permission checks
Next
From: Jeff Davis
Date:
Subject: Re: Enabling Checksums