Re: Load distributed checkpoint

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Load distributed checkpoint
Date: 2006-12-19 09:31:27
Message-ID: 20061219182412.6492.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> wrote:

> I performed some simple tests, and I'll show the results below.

> (1) The default case
> 235 80 226 77 240
> (2) No write case
> 242 250 244 253 280
> (3) No checkpoint case
> 229 252 256 292 276
> (4) No fsync() case
> 236 112 215 216 221
> (5) No write by PostgreSQL, but fsync() by another program case
> 9 223 260 283 292
> (6) case (5) + O_SYNC by write_fsync
> 97 114 126 112 125
> (7) O_SYNC case
> 182 103 41 50 74

I posted a patch to PATCHES. Please try out it.
It does write() smoothly, but fsync() at a burst.
I suppose the result will be between (3) and (5).

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-12-19 09:58:48 Re: Enums patch v2
Previous Message Csaba Nagy 2006-12-19 09:27:10 Re: Second attempt, roll your own autovacuum

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2006-12-19 09:48:03 Re: Updated XML patch
Previous Message ITAGAKI Takahiro 2006-12-19 09:17:10 Load distributed checkpoint patch