Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7A8BD476B6F for ; Tue, 14 Jan 2003 11:40:53 -0500 (EST) Received: from web21107.mail.yahoo.com (web21107.mail.yahoo.com [216.136.227.109]) by postgresql.org (Postfix) with SMTP id 6B27347608D for ; Tue, 14 Jan 2003 11:38:20 -0500 (EST) Message-ID: <20030114163825.45392.qmail@web21107.mail.yahoo.com> Received: from [131.142.161.245] by web21107.mail.yahoo.com via HTTP; Tue, 14 Jan 2003 08:38:25 PST Date: Tue, 14 Jan 2003 08:38:25 -0800 (PST) From: CaptainX0r Reply-To: captainx0r@yahoo.com Subject: Re: Sun vs. Mac To: pgsql-performance@postgresql.org In-Reply-To: <20030114110852.E5335@mail.libertyrms.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/92 X-Sequence-Number: 739 > 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