Strange Performance Problem.

From: Manuel Duran Aguete <mdaguete(at)alsernet(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange Performance Problem.
Date: 2001-11-13 03:01:49
Message-ID: 1005620588.31494.2.camel@dt1010.quantum.int
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I'm developing a application, usign linux, to run in Solaris. I'm usign
perl with DBD::Pg. When I test it on Linux (P4 1.5Ghz + 128 Mb) I' get
more performance than in a two Sun Enterprise 220R, with dual processor
and 2048 Mb RAM. & Solaris 7 Server, the Sun performance is a half than
linux. The main differences are :

In Linux the test are only in machine (Perl 5.6.0 + APP + PGSQL 7.1.2).
the PGSLQ parameter are:
sort_mem = 8192
shared_buffers = 1024
fsync = false

In Solaris I've have a machine for APP (Perl 5.6.1) an another for
PGSQL 7.1.2). usign a tcp network: The PGSQL parameters are:
sort_mem = 65536
shared_buffers =3040
fsync = true
max connections = 512

It's postgresql more optimized for linux?
Must have Solaris fsync = false ?
or simply I am crazy :-))))?

Browse pgsql-general by date

  From Date Subject
Next Message Sharon Cowling 2001-11-13 04:43:00 Outer Joins
Previous Message Bruce Momjian 2001-11-13 01:08:54 Re: [general] Permissions