Re: Low Budget Performance, Part 2

From: Richard Huxton <richardh(at)archonet(dot)com>
To: eric soroos <eric-psql(at)soroos(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Low Budget Performance, Part 2
Date: 2002-11-28 09:31:39
Message-ID: 200211280931.39873.richardh@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2002-11-28 12:05:17 Re: Low Budget Performance, Part 2
Previous Message eric soroos 2002-11-27 20:45:39 Re: Low Budget Performance, Part 2