Re: initdb and fsync - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: initdb and fsync
Date
Msg-id 87y5sinvne.fsf@mid.deneb.enyo.de
Whole thread Raw
In response to Re: initdb and fsync  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* Tom Lane:

> I wonder whether it wouldn't be sufficient to call sync(2) at the end,
> anyway, rather than cluttering the entire initdb codebase with fsync
> calls.

We tried to do this in the Debian package mananger.  It works as
expected on Linux systems, but it can cause a lot of data to hit the
disk, and there are kernel versions where sync(2) never completes if
the system is rather busy.

initdb is much faster with 9.1 than with 8.4.  It's so fast that you
can use it in test suites, instead of reusing an existing cluster.
I think this is a rather desirable property.


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [v9.2] Add GUC sepgsql.client_label
Next
From: Jeff Davis
Date:
Subject: Re: initdb and fsync