From: | Takashi Horikawa <t-horikawa(at)aj(dot)jp(dot)nec(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Partitioned checkpointing |
Date: | 2015-09-11 01:37:19 |
Message-ID: | 73FA3881462C614096F815F75628AFCD035584D4@BPXM01GP.gisp.nec.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Feel free to do that. 200kB is well below this list's limits. (I'm not
> sure how easy it is to open .epsf files in today's systems, but .jpg or
> other raster image formats are pretty common.)
Thanks for your comment.
Please find two result graphs (for sync and async commit cases) in .jpg format.
I think it is obvious that performance dips were mitigated in both magnitude and frequency by introducing the partitioned checkpointing.
(In passing) one correction for my previous email.
> Storage: raid1 of 4 HDs (write back assumed using BBU) for $PGDATA/pg_xlog
> raid1 of 2 SSDs for $PGDATA (other than pg_xlog)
'raid1' is wrong and 'raid0' is correct.
--
Takashi Horikawa
NEC Corporation
Knowledge Discovery Research Laboratories
> -----Original Message-----
> From: Alvaro Herrera [mailto:pgsql-hackers-owner(at)postgresql(dot)org]
> Sent: Friday, September 11, 2015 12:03 AM
> To: Horikawa Takashi(堀川 隆)
> Subject: Re: [HACKERS] Partitioned checkpointing
>
> Takashi Horikawa wrote:
>
> > # Since I'm not sure whether it is OK to send an email to this mailing
> > with attaching some files other than patch, I refrain now from
> > attaching raw results (200K bytes of text/case) and result graphs in
> > .jpg or .epsf format illustrating the throughput variations to this
> > email. If it is OK, I'm pleased to show the results in those formats.
>
> Feel free to do that. 200kB is well below this list's limits. (I'm not
> sure how easy it is to open .epsf files in today's systems, but .jpg or
> other raster image formats are pretty common.)
>
> --
> Álvaro Herrera
Attachment | Content-Type | Size |
---|---|---|
image/jpeg | 48.5 KB | |
image/jpeg | 47.7 KB | |
smime.p7s | application/pkcs7-signature | 6.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2015-09-11 01:39:50 | Re: Autonomous Transaction is back |
Previous Message | Michael Paquier | 2015-09-11 01:15:00 | Re: Support for N synchronous standby servers - take 2 |