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

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>

To: Simon Riggs <simon@2ndquadrant.com>

Cc: 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-08T01:44:24Z

Lists: pgsql-hackers

> 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