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.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
