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