Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6A5614767C1 for ; Tue, 14 Jan 2003 12:51:00 -0500 (EST) Received: from web21101.mail.yahoo.com (web21101.mail.yahoo.com [216.136.227.103]) by postgresql.org (Postfix) with SMTP id 4B8D84765D2 for ; Tue, 14 Jan 2003 12:49:59 -0500 (EST) Message-ID: <20030114175004.15074.qmail@web21101.mail.yahoo.com> Received: from [131.142.161.245] by web21101.mail.yahoo.com via HTTP; Tue, 14 Jan 2003 09:50:04 PST Date: Tue, 14 Jan 2003 09:50:04 -0800 (PST) From: CaptainX0r Reply-To: captainx0r@yahoo.com Subject: Re: Sun vs. Mac To: pgsql-performance@postgresql.org In-Reply-To: <16237.1042560292@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/95 X-Sequence-Number: 742 > I'd suggest starting with some elementary measurements, for > example looking at I/O rates and CPU idle percentage while > running the same task on both Solaris and G3. That would at > least give us a clue whether I/O or CPU is the bottleneck. Well, I've got the Sun box now, but I don't really have acces to the G3. FWIW, top shows postgres slowly taking up all the CPU - over the course of a minute or so it gradually ramps up to around 90%. Once the query is complete, however, top shows the CPU ramping down slowly, ~1-2% per second over the next 2 minutes which I find very strange. The CPU idle is 0% for the duration of the query, while the user state is around 100% for the same period. This kind of makes me think top is wrong (100% idle and 75% postgres?) iostat gives: (sorry for line wrap). # iostat -DcxnzP cpu us sy wt id 10 1 4 85 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 11.2 1.0 65.5 13.1 0.1 0.1 9.5 9.6 0 3 c1t0d0s0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 6.0 0 0 c1t0d0s1 7.3 0.1 502.3 0.5 0.0 0.0 0.0 2.3 0 1 c1t0d0s3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.1 0 0 host:vold(pid313) This doesn't really tell me much, except I'm guessing that PG is CPU bound? -X __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com