Re: Migration study, step 1: bulk write performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Mikael Carneholm <Mikael(dot)Carneholm(at)WirelessCar(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Migration study, step 1: bulk write performance
Date: 2006-03-21 12:10:32
Message-ID: 20060321121032.GB12963@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-21 12:18:39 Re: Migration study, step 1: bulk write performance
Previous Message Jim C. Nasby 2006-03-21 12:01:58 Re: Migration study, step 1: bulk write performance