Re: Postgresql Performance on an HP DL385 and - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Postgresql Performance on an HP DL385 and
Date
Msg-id 20060815222323.GA18180@uio.no
Whole thread Raw
In response to Re: Postgresql Performance on an HP DL385 and  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Postgresql Performance on an HP DL385 and  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Tue, Aug 15, 2006 at 05:20:25PM -0500, Jim C. Nasby wrote:
> This is only valid if the pre-allocation is also fsync'd *and* fsync
> ensures that both the metadata and file data are on disk. Anyone
> actually checked that? :)

fsync() does that, yes. fdatasync() (if it exists), OTOH, doesn't sync the
metadata.

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

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Postgresql Performance on an HP DL385 and
Next
From: David Lang
Date:
Subject: Re: Postgresql Performance on an HP DL385 and