pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (20+ messages)  latest in thread

Message-ID: <3E242826.8020306@postgresql.org>
Permalink:  ../3E242826.8020306@postgresql.org/
Also on:    postgresql.org/message-id/3E242826.8020306@postgresql.org

 · 

reply

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