Re: Detach/attach table and index data files from one cluster to another

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Detach/attach table and index data files from one cluster to another
Дата
Msg-id 20130412184928.GM4361@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Detach/attach table and index data files from one cluster to another  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Kohei KaiGai
Дата:
Сообщение: Re: [sepgsql 2/3] Add db_schema:search permission checks
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Enabling Checksums