Re: Low Budget Performance, Part 2 - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Low Budget Performance, Part 2
Date
Msg-id 200211280931.39873.richardh@archonet.com
Whole thread Raw
In response to Re: Low Budget Performance, Part 2  (eric soroos <eric-psql@soroos.net>)
Responses Re: Low Budget Performance, Part 2
List pgsql-performance
On Wednesday 27 Nov 2002 8:45 pm, eric soroos wrote:
> Ok, with the scaling factor set at 20, the new results are more in line
> with expectations:
>
> For 1-10 clients, IDE gets 25-30 tps, SCSI 40-50  (more with more clients,
> roughly linear).
>
> The CPU was hardly working in these runs (~50% on scsi, ~20% on ide), vs
> nearly 100% on the previous run.
>
> I'm suspect that the previous runs were colored by having the entire
> dataset in memory as well as the update contention.

A run of vmstat while the test is in progress might well show what's affecting
performance here.

--
  Richard Huxton
  Archonet Ltd

pgsql-performance by date:

Previous
From: eric soroos
Date:
Subject: Re: Low Budget Performance, Part 2
Next
From: Ron Johnson
Date:
Subject: Re: Low Budget Performance, Part 2