Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CA79B4761AD for ; Tue, 14 Jan 2003 13:02:27 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 85FF4476B78 for ; Tue, 14 Jan 2003 12:58:42 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18YVKq-0005oX-00 for ; Tue, 14 Jan 2003 12:58:48 -0500 Date: Tue, 14 Jan 2003 12:58:48 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Sun vs. Mac Message-ID: <20030114125848.P5335@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <16237.1042560292@sss.pgh.pa.us> <20030114175004.15074.qmail@web21101.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20030114175004.15074.qmail@web21101.mail.yahoo.com>; from captainx0r@yahoo.com on Tue, Jan 14, 2003 at 09:50:04AM -0800 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/96 X-Sequence-Number: 743 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 M2P 2A8 +1 416 646 3304 x110