On Wed, Feb 08, 2006 at 09:44:24AM +0800, Christopher Kings-Lynne wrote: > >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?
Yes. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq