Re: Load distributed checkpoint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Load distributed checkpoint
Date: 2006-12-29 21:43:24
Message-ID: 17799.1167428604@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Jim C. Nasby" <jim(at)nasby(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-12-29 21:44:39 Re: [HACKERS] Recent SIGSEGV failures in buildfarm HEAD
Previous Message Tom Lane 2006-12-29 21:41:11 Re: Dead Space Map for vacuum

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-12-29 21:44:39 Re: [HACKERS] Recent SIGSEGV failures in buildfarm HEAD
Previous Message Andrew Dunstan 2006-12-29 21:20:51 Re: [HACKERS] Recent SIGSEGV failures in buildfarm HEAD