Re: 8.3 synchronous_commit

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Subject: Re: 8.3 synchronous_commit
Date: 2008-01-22 12:13:57
Message-ID: 4795DE05.7060109@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Smith wrote:
> Try something more in the range of 4 clients/CPU and set the scale to
> closer to twice that (so with a dual-core system you might do 8 clients
> and a scale of 16). If you really want to simulate a large number of
> clients, do that on another system and connect to the server remotely.

With 4 clients and scale 10 I get 246 TPS for synchronous_commit
disabled and 634 TPS for synchronous_commit enabled. So the effect just
got even stronger. That was for CFQ.

For deadline they are now pretty close, but synchronous_commit disabled
is still slower. 690 to 727.

Values are AVG from 3 runs each. DROP/CREATE DATABASE and CHECKPOINT;
before each run.

--
Best regards,
Hannes Dorbath

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luiz K. Matsumura 2008-01-22 19:32:17 Optimizing queries that use temporary tables
Previous Message Hannes Dorbath 2008-01-22 11:56:59 Re: 8.3 synchronous_commit