Re: Migration study, step 1: bulk write performance - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Migration study, step 1: bulk write performance
Date
Msg-id 20060321121032.GB12963@uio.no
Whole thread Raw
In response to Re: Migration study, step 1: bulk write performance  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Migration study, step 1: bulk write performance
List pgsql-performance
On Tue, Mar 21, 2006 at 06:01:58AM -0600, Jim C. Nasby wrote:
> Are you sure? Metadate changes are probably a lot more common on the WAL
> partition. In any case, I don't see why there should be a difference.
> The real issue is: is related filesystem metadata sync'd as part of a
> file being fsync'd?

I've been told on this list that PostgreSQL actually takes care to fill a new
WAL file with zeroes etc. when initializing it; dig a few months back and I'm
sure it's there.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Migration study, step 1: bulk write performance
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Migration study, step 1: bulk write performance