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
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 |
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 |