Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BD5249F9612 for ; Tue, 21 Aug 2007 12:50:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 60735-04 for ; Tue, 21 Aug 2007 12:49:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gmp-ea-fw-1.sun.com (gmp-ea-fw-1.sun.com [192.18.1.36]) by postgresql.org (Postfix) with ESMTP id 6DBE89F9599 for ; Tue, 21 Aug 2007 12:49:59 -0300 (ADT) Received: from d1-emea-10.sun.com ([192.18.2.120]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l7LFnvo2020163 for ; Tue, 21 Aug 2007 15:49:57 GMT Received: from conversion-daemon.d1-emea-10.sun.com by d1-emea-10.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JN400C01RWPZU00@d1-emea-10.sun.com> (original mail from Julius.Stroffek@Sun.COM) for pgsql-performance@postgresql.org; Tue, 21 Aug 2007 16:49:57 +0100 (BST) Received: from [129.157.18.88] by d1-emea-10.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JN4006D9RZ8T2SM@d1-emea-10.sun.com>; Tue, 21 Aug 2007 16:49:57 +0100 (BST) Date: Tue, 21 Aug 2007 17:49:13 +0200 From: Julius Stroffek Subject: Re: Performance Solaris vs Linux In-reply-to: To: Fredrik Bertilsson Cc: pgsql-performance@postgresql.org Reply-to: pgsql-performance@postgresql.org Message-id: <46CB0979.7050104@Sun.COM> MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_PinKthFA0lmjKAn0kus8jg)" References: User-Agent: Thunderbird 1.5.0.8 (X11/20061204) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/212 X-Sequence-Number: 26342 This is a multi-part message in MIME format. --Boundary_(ID_PinKthFA0lmjKAn0kus8jg) Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT Hi Frederick, There is an article about tunning the performance of PostgreSQL on Solaris at http://tweakers.net/reviews/649/9 which is not quite exactly of what you wanted but it might help you. I think that Solaris has disk cache turned off by default which linux does not have due to possible data loss in case of a power failure. Regards, Julo 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 --Boundary_(ID_PinKthFA0lmjKAn0kus8jg) Content-type: text/html; charset=ISO-8859-1 Content-transfer-encoding: 7BIT Hi Frederick,

There is an article about tunning the performance of PostgreSQL on Solaris at
http://tweakers.net/reviews/649/9

which is not quite exactly of what you wanted but it might help you.

I think that Solaris has disk cache turned off by default which linux does not have
due to possible data loss in case of a power failure.

Regards,

Julo

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
--Boundary_(ID_PinKthFA0lmjKAn0kus8jg)--