Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DBBD6475EE4 for ; Tue, 14 Jan 2003 12:33:07 -0500 (EST) Received: from localhost.localdomain (sein.itera.ee [194.126.109.126]) by postgresql.org (Postfix) with ESMTP id 2F4E1476315 for ; Tue, 14 Jan 2003 12:32:34 -0500 (EST) Received: (from hannu@localhost) by localhost.localdomain (8.11.6/8.11.6) id h0EJQPo15967; Tue, 14 Jan 2003 19:26:25 GMT X-Authentication-Warning: localhost.localdomain: hannu set sender to hannu@tm.ee using -f Subject: Re: Sun vs. Mac From: Hannu Krosing To: captainx0r@yahoo.com Cc: "pgsql-performance@postgresql.org" In-Reply-To: <20030114150008.49425.qmail@web21103.mail.yahoo.com> References: <20030114150008.49425.qmail@web21103.mail.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Organization: Message-Id: <1042572384.15544.84.camel@huli> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 14 Jan 2003 19:26:24 +0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/94 X-Sequence-Number: 741 On Tue, 2003-01-14 at 15:00, CaptainX0r wrote: > Hello, > > I'm having some serious performance issues with PostgreSQL on > our newish SunFire 280R (1 900MHz ultrasparc III, 1 GB RAM). > It's painfully slow. It took me almost a week of tuning to get > it in the range of an old Mac G3 laptop. Now, a few days later, > after tweaking every nearly every parameter (only noting > decreased performance on some) in /etc/system and > $PGDATA/postgresql.conf could you post your $PGDATA/postgresql.conf for our viewing pleasure ? > it's about as fast as I can make it, but > still horribly slow. A few simple queries that take 1.5-7 > minutes on the G3 take 1-1.5 minutes on the Sun. A bulk load of > roughly 2.4 GB database dump takes ~1 hour on each machine. It > took almost 2 hours on the Sun before I turned off fsync. > > We have plans to add another CPU, RAM and another disk, which > should all help, Another CPU will probably not help with bulk loads or other single-user stuff. > but in its current state, I (and many others) > would think that it should run circles around the G3. I'm > thinking that I'm missing something big and obvious because this > can't be right. Otherwise we might as well just get a bunch of > ibooks to run our databases - they're a lot smaller and much > more quiet. For single-user tasks you will probably be better off by getting a gray box with Athlon 2600+ with 3 Gigs of memory and IDE disks and running Linux or *BSD . > Can someone please point me in the right direction? > > Thanks, > > -X > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- Hannu Krosing