Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6D9299F9A72 for ; Sat, 18 Aug 2007 07:13:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 67598-10 for ; Sat, 18 Aug 2007 07:13:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp2.hushmail.com (smtp2.hushmail.com [65.39.178.134]) by postgresql.org (Postfix) with ESMTP id DC3E79F9A6F for ; Sat, 18 Aug 2007 07:13:50 -0300 (ADT) Received: from smtp2.hushmail.com (localhost [127.0.0.1]) by smtp2.hushmail.com (Postfix) with SMTP id 16A9E1702E for ; Sat, 18 Aug 2007 10:13:49 +0000 (UTC) Message-ID: <46C6C659.8060703@1006.org> Date: Sat, 18 Aug 2007 12:13:45 +0200 From: Chris Mair MIME-Version: 1.0 To: Fredrik Bertilsson CC: pgsql-performance@postgresql.org Subject: Re: Performance Solaris vs Linux References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.071 tagged_above=0 required=5 tests=AWL=-0.827, BAYES_40=-0.185, URIBL_RHS_DOB=1.083 X-Spam-Level: X-Archive-Number: 200708/189 X-Sequence-Number: 26319 Fredrik Bertilsson wrote: > 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? > > Best regards, > Fredrik B I had some performance problems on Solaris a while ago which let to this interesting thread: http://archives.postgresql.org/pgsql-performance/2006-04/thrd4.php#00035 executive summary: - write cache might be (unexpectedly) off by default on sun gear - set explicitly "wal_sync_method = fsync" - some other settings (see thread) Bye, Chris.