| 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: | Whole Thread | Raw Message | 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 :-))))?
| 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 |