Re: Fastest way to restore a database

Scott Ribe <scott_ribe@killerbytes.com> writes:
>> The worry expressed upthread about the transaction being "too large" is
>> unfounded, btw.  Unlike some other DBs, PG doesn't have a finite-size
>> undo log.

> Sure, it won't fail. But would there be some point at which it would become
> slower than multiple transactions? Or is it always faster (or at least as
> fast)?

I can't think of any reason it would be slower.

There are certainly issues you could run into with very long
transactions, like vacuum not being able to remove bloat elsewhere.

            regards, tom lane