> This would apply to only a single relation, so would be just as
> efficient a write to the database as to WAL. The proposed route is to
> sync to the database, but not to WAL, thus halving the required I/O.
>
> Yes, its designed for large data loads.
A question - would setting fsync=off while restoring a multi-gig dump
(during an upgrade) improve performance?
Chris