Re: Load distributed checkpoint - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Load distributed checkpoint
Date
Msg-id 17799.1167428604@sss.pgh.pa.us
Whole thread Raw
In response to Re: Load distributed checkpoint  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Load distributed checkpoint  (Bruce Momjian <bruce@momjian.us>)
Re: Load distributed checkpoint  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> I believe there's something similar for OS X as well. The question is:
> would it be better to do that, or to just delay calling fsync until the
> OS has had a chance to write things out.

A delay is not going to help unless you can suppress additional writes
to the file, which I don't think you can unless there's very little
going on in the database --- dirty buffers have to get written to make
room for other pages, checkpoint in progress or no.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dead Space Map for vacuum
Next
From: Alvaro Herrera
Date:
Subject: Re: effective_cache_size vs units