Re: Sun vs. Mac

From: CaptainX0r <captainx0r(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sun vs. Mac
Date: 2003-01-14 16:38:25
Message-ID: 20030114163825.45392.qmail@web21107.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> You'll need to increase the number of available semaphores
> more than
> likely, if you add any connections. You do indeed need to fix
> shmmax, but if the postmaster starts, you're fine.

Thanks, I'll take a closer look at this.

> That's what you need. Without any doubt at all. The xlog on
> the same UFS filesystem (and disk) as the rest of $PGDATA is a
> nightmare.

The disks are on order - but that can't be the only thing hold
it up, can it? I've got to check out the IO, as you suggest.

> > > Also, certain sort routines are abysmal. Replace the
> > > Solaris-provided qsort().
> >
> > I've read about this as well - but haven't even gotten that
> > far on the testing/configuring yet.
>
> If you're doing any sorting that is not by an index, forget
> about it.
> Change it now. It's something like a multiple of 40 slower.

I double checked, and this was one of the reasons I was glad to
try 7.3 on Solaris - it's already got it built in.

Thanks much for the input,

-X

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message CaptainX0r 2003-01-14 16:54:33 Re: Sun vs. Mac
Previous Message CaptainX0r 2003-01-14 16:29:57 Re: Sun vs. Mac