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

From Andrew Dunstan
Subject Re: Detach/attach table and index data files from one cluster to another
Date
Msg-id 51682D77.2090903@dunslane.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
Re: Detach/attach table and index data files from one cluster to another
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Patch to make pgindent work cleanly
Next
From: Tom Lane
Date:
Subject: Re: Analyzing bug 8049