Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A9149475D01 for ; Tue, 14 Jan 2003 14:39:11 -0500 (EST) Received: from web21106.mail.yahoo.com (web21106.mail.yahoo.com [216.136.227.108]) by postgresql.org (Postfix) with SMTP id 5A8F24765D2 for ; Tue, 14 Jan 2003 14:38:28 -0500 (EST) Message-ID: <20030114193828.37133.qmail@web21106.mail.yahoo.com> Received: from [131.142.161.245] by web21106.mail.yahoo.com via HTTP; Tue, 14 Jan 2003 11:38:28 PST Date: Tue, 14 Jan 2003 11:38:28 -0800 (PST) From: CaptainX0r Reply-To: captainx0r@yahoo.com Subject: Re: Sun vs. Mac To: pgsql-performance@postgresql.org In-Reply-To: <17342.1042568154@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/107 X-Sequence-Number: 754 > I believe top's percent-of-CPU numbers for individual > processes are time > averages over a minute or so, so the ramping effect is > unsurprising. Thanks - this makes much more sense. > > This doesn't really tell me much, except I'm guessing that > > PG is CPU bound? > > Yup, that seems pretty clear. Next step is to find out what > the heck > it's doing. My instinct would be to use gprof. Recompile > with > profiling enabled --- if you're using gcc, this should work > cd postgres-distribution/src/backend > make clean > make PROFILE=-pg all > make install-bin -- may need to stop postmaster > Next run some sample queries (put them all into one session). > After quitting the session, find gmon.out in the > $PGDATA/base/nnn/ subdirectory corresponding to your database, > and feed it to gprof. > The results should show where the code hotspot is. Well if that isn't a fancy bit of info.... Thanks! gprof says: Fatal ELF error: can't read ehdr (Request error: class file/memory mismatch) I'm guessing that's not what we're expecting... I'm using /usr/ccs/bin/gprof - maybe there's a better one? -X __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com