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