>>>>> "BM" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
BM> COPY only does fsync on COPY completion, so I am not sure there are
BM> enough fsync's there to make a difference.
Perhaps then it is part of the indexing that takes so much time with
the WAL. When I applied Marc's WAL disabling patch, it shaved nearly
50 minutes off of a 4-hour restore.
I sent to Tom the logs from the restores since he was interested in
figuring out where the time was saved.