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 0E7C252C70 for ; Thu, 14 Jul 2005 04:00:49 -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 96547-08 for ; Thu, 14 Jul 2005 07:00:41 +0000 (GMT) Received: from intranet.squiz.net (extranet.squiz.net [203.222.154.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2C11052C2B for ; Thu, 14 Jul 2005 04:00:40 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by intranet.squiz.net (Postfix) with ESMTP id 3916C3788D; Thu, 14 Jul 2005 17:00:38 +1000 (EST) Received: from intranet.squiz.net ([127.0.0.1]) by localhost (intranet [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00768-08; Thu, 14 Jul 2005 17:00:38 +1000 (EST) Received: from [192.168.0.116] (116.squiz.net [192.168.0.116]) by intranet.squiz.net (Postfix) with ESMTP id F2FBF37885; Thu, 14 Jul 2005 17:00:37 +1000 (EST) Message-ID: <42D60D54.6020709@squiz.net> Date: Thu, 14 Jul 2005 16:59:32 +1000 From: Marc McIntyre User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: rjhb@bb-c.de Cc: pgsql-admin@postgresql.org Subject: Re: Anyone running PostgreSQL on Sun Solaris? References: <42CEDA40.3060707@sermonaudio.com> <42D5F9B3.5060305@squiz.net> <40784.193.194.7.77.1121321363.squirrel@193.194.7.77> In-Reply-To: <40784.193.194.7.77.1121321363.squirrel@193.194.7.77> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at squiz.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/97 X-Sequence-Number: 18153 Rainer J. H. Brandt wrote: >>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? > > It been too long to remember exact specifics, but it was something very similar to this problem. http://sunportal.sunmanagers.org/pipermail/summaries/2003-March/003254.html You might also want to have a look at this, although most of these issues are very old and have probably been resolved by now. http://www.phil.uni-erlangen.de/tree/postgresql/majordomo/pgsql-novice-digest/v01.n098 >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 > > > > >---------------------------(end of broadcast)--------------------------- >TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > > -- Marc McIntyre MySource Matrix Lead Developer