Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C47214764E6 for ; Tue, 14 Jan 2003 11:58:50 -0500 (EST) Received: from web21110.mail.yahoo.com (web21110.mail.yahoo.com [216.136.227.112]) by postgresql.org (Postfix) with SMTP id 3984D47656B for ; Tue, 14 Jan 2003 11:54:28 -0500 (EST) Message-ID: <20030114165433.63951.qmail@web21110.mail.yahoo.com> Received: from [131.142.161.245] by web21110.mail.yahoo.com via HTTP; Tue, 14 Jan 2003 08:54:33 PST Date: Tue, 14 Jan 2003 08:54:33 -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/93 X-Sequence-Number: 740 All, > Let me get this straight: the Sun is slower even with fsync > off? That Correct. This really helped a lot, especially with the dump load, but I've clearly got some more work ahead of me. > Andrew Sullivan's nearby recommendation to replace qsort() is > a good > one, but PG 7.3 is already configured to do that by default. > (Look in > src/Makefile.global to confirm that qsort.o is mentioned in > LIBOBJS.) Thanks for confirming. I've got LIBOBJS = isinf.o qsort.o > 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. Good thoughts - I'm working on it right now, though I'm not really sure how to check I/O rates.... Thanks much for the input, -X __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com