X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C4DFC52D48 for ; Thu, 14 Jul 2005 03:09:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84734-09 for ; Thu, 14 Jul 2005 06:09:27 +0000 (GMT) Received: from p15154245.pureserver.info (www.forth-edv-services.de [82.165.34.16]) by svr1.postgresql.org (Postfix) with ESMTP id 5E98252D47 for ; Thu, 14 Jul 2005 03:09:24 -0300 (ADT) Received: from www.nachrichten-zentrale.net (localhost.localdomain [127.0.0.1]) by p15154245.pureserver.info (Postfix) with ESMTP id 541F6C02650; Thu, 14 Jul 2005 08:09:23 +0200 (CEST) Received: from 193.194.7.77 (SquirrelMail authenticated user rainerb); by www.nachrichten-zentrale.net with HTTP; Thu, 14 Jul 2005 08:09:23 +0200 (CEST) Message-ID: <40784.193.194.7.77.1121321363.squirrel@193.194.7.77> In-Reply-To: <42D5F9B3.5060305@squiz.net> References: <42CEDA40.3060707@sermonaudio.com> <42D5F9B3.5060305@squiz.net> Date: Thu, 14 Jul 2005 08:09:23 +0200 (CEST) Subject: Re: Anyone running PostgreSQL on Sun Solaris? From: "Rainer J. H. Brandt" To: pgsql-admin@postgresql.org Reply-To: rjhb@bb-c.de User-Agent: SquirrelMail/1.4.3-RC1 X-Mailer: SquirrelMail/1.4.3-RC1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/96 X-Sequence-Number: 18152 > A while ago we had a client running PostgreSQL on a Quad v440, and the > performance was horrific. There are some known issues with PostgreSQL > and solaris. AFAIK there was a kernel patch to alleviate some of the > issues, but i'm unsure of the state of this as its been sometime since > i've had any experience with PostgreSQL and solaris. Can anyone remember specific information? The only detail I remember about performance under Solaris is a discussion about slow qsort: http://archives.postgresql.org/pgsql-hackers/2002-04/msg00103.php A quick search didn't turn up information about whether the build process now replaces Sun's qsort, or whether Sun has improved qsort since the problem was noticed by postgres users in 2002. It'd be interesting to invest some time studying the sources at opensolaris.org. Rainer ---------------------------------------------------------------------- Rainer J. H. Brandt email: rjhb@bb-c.de Brandt & Brandt Computer GmbH web: www.bb-c.de Kamberg 111 phone: +49 2448 919126 D 53940 Hellenthal mobile: +49 172 9593205