William Garrison <postgres@xxxxxxxxxxxx> 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
