Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BC1DF475E64 for ; Tue, 14 Jan 2003 10:06:17 -0500 (EST) Received: from new-smtp2.ihug.com.au (new-smtp2.ihug.com.au [203.109.250.28]) by postgresql.org (Postfix) with ESMTP id 1D69447580B for ; Tue, 14 Jan 2003 10:06:17 -0500 (EST) Received: from p96-tnt1.adl.ihug.com.au (postgresql.org) [203.173.248.96] by new-smtp2.ihug.com.au with esmtp (Exim 3.22 #1 (Debian)) id 18YSdv-0002Ef-00; Wed, 15 Jan 2003 02:06:20 +1100 Message-ID: <3E242826.8020306@postgresql.org> Date: Wed, 15 Jan 2003 01:39:26 +1030 From: Justin Clift User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: captainx0r@yahoo.com Cc: pgsql-performance@postgresql.org Subject: Re: Sun vs. Mac References: <20030114150008.49425.qmail@web21103.mail.yahoo.com> In-Reply-To: <20030114150008.49425.qmail@web21103.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/84 X-Sequence-Number: 731 Hi CaptainXOr, Which version of PostgreSQL, and which release of Solaris are you running? Regards and best wishes, Justin Clift 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 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, 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. > > 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 -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi