Skip site navigation (1) Skip section navigation (2)

tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)

From: Juan Pablo Sandoval Rivera <juapabsan(at)tutopia(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)
Date: 2010-05-25 14:04:07
Message-ID: 20100525140415.457ED6321D3@mail.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-performance
Good day list 

I would appreciate some comments to the following: 

I have a Dell PowerEdge SC1420 server with 2 GB of RAM 1 DD 73 Gb SCSI Ulltra320 2 Xeon (4 
cache) with PGSQL 7.3.7 

running GNU / Linux Red Hat Enterprise 4, 0 for 32-bit (kernel 2.6.9-5Elsmp) Nahant (ES) 

and another server start or operate the same system and database engine, HP Proliant ML 150 G6 
two Smart Array P410 Xeon 2 GB RAM, 2 DD Sata 15,000 RPM (250 GB) in RAID 1 

  

I'm validating the operation and Execution / time difference of a process between the two is 
not really maquians muicha few seconds almost no time to think it is just quicker the Dell 
machine, it must obviously affect the technology of hard drives. 

shmmax is set to 500.00.000, annex Execution / parameters of both machines pg_settings 
consultation. 

Please let me give recommendation to the confituracion, if this correct or would fail or left 
over tune. an average of 30 users use the system, and is heavy disk usage, uan table has 8 
million + another + 13 milloines, the 8 is used daily, desarfortunadame Progress can not yet 
migrate to 8.x, that tiempoi tiomaria a development, adjustment and testing, but it will fit 
with the current configuration that I mentioned. 

Thank you.


Juan Pablo Sandoval Rivera
Tecnologo Prof. en Ing. de Sistemas

Linux User : 322765 
msn    : juan_pablos(at)hotmail(dot)com
yahoo : juan_pablos(at)rocketmail(dot)com (juan_pablos.rm)
UIN     : 276125187 (ICQ)
Jabber : juan_pablos(at)www(dot)jabberES(dot)org
Skype  : juan.pablo.sandoval.rivera

APOYA A ECOSEARCH.COM - Ayuda a salvar al Planeta.




Attachment: 80173-settings_7.3.7hp
Description: application/octet-stream (2.1 KB)
Attachment: 80173-settings7.3.7dell
Description: application/octet-stream (2.1 KB)

Responses

pgsql-performance by date

Next:From: Joshua TolleyDate: 2010-05-25 14:27:01
Subject: Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86(2.6.9-5ELsmp)
Previous:From: Tyler HildebrandtDate: 2010-05-25 13:41:00
Subject: Re: Query timing increased from 3s to 55s when used as afunction instead of select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group