Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3B2F89FB42E for ; Sat, 18 Aug 2007 00:08:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 91472-05 for ; Sat, 18 Aug 2007 00:08:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 2297B9F96E5 for ; Sat, 18 Aug 2007 00:08:08 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-221-172.bk12-dsl.surnet.cl [201.221.221.172]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l7I38Akk023803; Fri, 17 Aug 2007 20:08:11 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id A4D6947C5A; Fri, 17 Aug 2007 23:08:04 -0400 (CLT) Date: Fri, 17 Aug 2007 23:08:04 -0400 From: Alvaro Herrera To: Fredrik Bertilsson Cc: pgsql-performance@postgresql.org Subject: Re: Performance Solaris vs Linux Message-ID: <20070818030804.GD13349@alvh.no-ip.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV 0.91.1/3967/Thu Aug 16 08:32:14 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 17 Aug 2007 20:08:12 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/188 X-Sequence-Number: 26318 Fredrik Bertilsson escribió: > Hi, > we are using Postgres on both Solaris servers and Linux servers, and > Postgres are much slower on Solaris servers. We have tested with different > versions of Solaris and Postgres, but the fact remains: Postgres seems to be > much faster on Linux server. Does anybody else has the same experience? You haven't specified where the slowness is. Is it that connection establishing is slower? Are queries slower? Is the hardware comparable? Are the filesystems configured similarly? -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J "Find a bug in a program, and fix it, and the program will work today. Show the program how to find and fix a bug, and the program will work forever" (Oliver Silfridge)