Horton
Menu

Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and

Jim Nasby <jnasby@pervasive.com>

View thread
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Simon Riggs <simon@2ndquadrant.com>, Rick Gigger <rick@alpinenetworking.com>, Bruce Momjian <pgman@candle.pha.pa.us>, Tom Lane <tgl@sss.pgh.pa.us>, Martijn van Oosterhout <kleptog@svana.org>, Greg Stark <gsstark@mit.edu>, Rod Taylor <pg@rbt.ca>, Qingqing Zhou <zhouqq@cs.toronto.edu>, pgsql-hackers@postgresql.org
Date: 2006-02-08T02:00:51Z
Lists: pgsql-hackers 
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      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461