Re: Sun vs. Mac - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Sun vs. Mac
Date
Msg-id 20030114125848.P5335@mail.libertyrms.com
Whole thread Raw
In response to Re: Sun vs. Mac  (CaptainX0r <captainx0r@yahoo.com>)
Responses Re: Sun vs. Mac  (CaptainX0r <captainx0r@yahoo.com>)
List pgsql-performance
On Tue, Jan 14, 2003 at 09:50:04AM -0800, CaptainX0r wrote:
> the G3.  FWIW, top shows postgres slowly taking up all the CPU -

Son't use top on Solaris 8.  It's inaccurate, and it affects the
results itself.  Use prstat instead.

> This doesn't really tell me much, except I'm guessing that PG is
> CPU bound?

It looks that way.  I've had iostat show CPU-bound, however, when the
problem actually turned out to be memory contention.  I think you may
want to have a poke with vmstat, and also have a look at the SE
toolkit.

A

----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-performance by date:

Previous
From: CaptainX0r
Date:
Subject: Re: Sun vs. Mac
Next
From: CaptainX0r
Date:
Subject: Re: Sun vs. Mac - best Postgres platform?