Re: Fastest way to restore a database

William Garrison <postgres@mobydisk.com> writes:
> So... if I am using pg_dump and pg_restore with a compressed backup,
> then it is using COPY, correct?  And I think that would follow a CREATE
> TABLE statement as mentioned in the first link... so no WAL files written?

Only if you use --single-transaction.

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.

            regards, tom lane