Philip Martin <philip.mar...@wandisco.com> writes: > did that it was taking over 17s). That's an order of magnitude slower > which could be a problem, the SELECT on the source will block writes > to the database during the copy.
Writing that has made me think of another solution. If we do a SELECT on the source database, that will block writers. At that point we can do a simple disk copy and be confident that the database will not change. -- Philip
