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

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Detach/attach table and index data files from one cluster to another
Дата
Msg-id 51682D77.2090903@dunslane.net
обсуждение исходный текст
Ответ на Re: Detach/attach table and index data files from one cluster to another  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Detach/attach table and index data files from one cluster to another  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Detach/attach table and index data files from one cluster to another  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 04/12/2013 10:15 AM, Tom Lane wrote:
> Sameer Thakur <samthakur74@gmail.com> writes:
>> The proposed tool tries to make migration faster for tables and indices
>> only by copying their binary data files.
> There's 0 chance of making that work, because the two databases wouldn't
> have the same notions of committed XIDs.


Yeah. Trying to think way outside the box, could we invent some sort of 
fixup mechanism that could be applied to adopted files? Of course, that 
could slow things down so much that it wouldn't be worth it, but it 
might be a nice research project.

cheers

andrew



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Patch to make pgindent work cleanly
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Analyzing bug 8049