Strange Performance Problem. - Mailing list pgsql-general

From Manuel Duran Aguete
Subject Strange Performance Problem.
Date
Msg-id 1005620588.31494.2.camel@dt1010.quantum.int
Whole thread Raw
List 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 :-))))?







Attachment

pgsql-general by date:

Previous
From: Orion
Date:
Subject: Re: What's the fastest way to do this?
Next
From: Stephan Szabo
Date:
Subject: Re: What's the fastest way to do this?