On 2/17/14, 7:31 PM, Robert Haas wrote:
> But do you really want to keep that snapshot around long enough to
> copy the entire database? I bet you don't: if the database is big,
> holding back xmin for long enough to copy the whole thing isn't likely
> to be fun.
I can confirm that this would be epic fail, at least for londiste. It takes about 3 weeks for a new copy of a ~2TB
database.There's no way that'd work with one snapshot. (Granted, copy performance in londiste is rather lackluster, but
still...)
--
Jim C. Nasby, Data Architect jim@nasby.net
512.569.9461 (cell) http://jim.nasby.net