From: Justin Clift <justin@postgresql.org>
To: captainx0r@yahoo.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Sun vs. Mac
Date: Wed, 15 Jan 2003 01:39:26 +1030
Message-ID: <3E242826.8020306@postgresql.org> (raw)
In-Reply-To: <20030114150008.49425.qmail@web21103.mail.yahoo.com>
References: <20030114150008.49425.qmail@web21103.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: justin@postgresql.org, captainx0r@yahoo.com
Subject: Re: Sun vs. Mac
In-Reply-To: <3E242826.8020306@postgresql.org>
References: <20030114150008.49425.qmail@web21103.mail.yahoo.com> <3E242826.8020306@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox