From: | Fernando Ike <fike(at)midstorm(dot)org> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: 8.3 synchronous_commit |
Date: | 2008-01-22 00:48:21 |
Message-ID: | 20080121224821.22c2a800@pmanson |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Em Mon, 21 Jan 2008 15:45:54 -0800
Jeff Davis <pgsql(at)j-davis(dot)com> escreveu:
> On Mon, 2008-01-21 at 18:31 -0500, Greg Smith wrote:
> > pgbench doesn't handle 100 clients at once very well on the same
> > box as the server, unless you have a pretty serious system. The
> > pgbench program itself has a single process model that doesn't
> > handle the CFQ round-robin very well at all. On top of that, the
> > database scale should be bigger
>
> He was referring to the CFQ I/O scheduler. I don't think that will
> affect pgbench itself, because it doesn't read/write to disk, right?
>
No. But pgbench local running, it will be concurrency with
PostgreSQL. I'm realized some test and really confirm disable
*synchronous_commit* performance degrade with CFQ and Deadline.
Kind Regards,
--
Fernando Ike
http://www.midstorm.org/~fike/weblog
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Moisey | 2008-01-22 07:00:53 | scheduler |
Previous Message | Greg Smith | 2008-01-22 00:26:14 | Re: 8.3 synchronous_commit |