pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Mair <chris@1006.org>
To: Fredrik Bertilsson <frebe73@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Solaris vs Linux
Date: Sat, 18 Aug 2007 12:13:45 +0200
Message-ID: <46C6C659.8060703@1006.org> (raw)
In-Reply-To: <a4bdbee90708162350j56004afwfb26626dd6d53e8a@mail.gmail.com>
References: <a4bdbee90708162350j56004afwfb26626dd6d53e8a@mail.gmail.com>

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.





view thread (4+ messages)  latest in thread

Message-ID: <46C6C659.8060703@1006.org>
Permalink:  ../46C6C659.8060703@1006.org/
Also on:    postgresql.org/message-id/46C6C659.8060703@1006.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: chris@1006.org, frebe73@gmail.com
  Subject: Re: Performance Solaris vs Linux
  In-Reply-To: <46C6C659.8060703@1006.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox