Re: Sun vs. Mac

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sun vs. Mac
Date: 2003-01-14 17:58:48
Message-ID: 20030114125848.P5335@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message CaptainX0r 2003-01-14 18:10:54 Re: Sun vs. Mac - best Postgres platform?
Previous Message CaptainX0r 2003-01-14 17:50:04 Re: Sun vs. Mac