pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedtunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)
2+ messages / 2 participants
[nested] [flat]
* tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)
@ 2010-05-25 14:04 Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
2010-05-25 14:27 ` Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) Joshua Tolley <eggyknap@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Juan Pablo Sandoval Rivera @ 2010-05-25 14:04 UTC (permalink / raw)
To: 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@hotmail.com
yahoo : juan_pablos@rocketmail.com (juan_pablos.rm)
UIN : 276125187 (ICQ)
Jabber : juan_pablos@www.jabberES.org
Skype : juan.pablo.sandoval.rivera
APOYA A ECOSEARCH.COM - Ayuda a salvar al Planeta.
Attachments:
80173-settings7.3.7dell (application/octet-stream, 2.1K) download
80173-settings_7.3.7hp (application/octet-stream, 2.1K) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)
2010-05-25 14:04 tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
@ 2010-05-25 14:27 ` Joshua Tolley <eggyknap@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joshua Tolley @ 2010-05-25 14:27 UTC (permalink / raw)
To: Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>; +Cc: pgsql-performance
On Tue, May 25, 2010 at 02:04:07PM +0000, Juan Pablo Sandoval Rivera wrote:
> Please let me give recommendation to the confituracion...
The subject line of this message said you're trying to run PostgreSQL 7.3.7. I
hope that's a typo, and you really mean 8.3.7, in which case this suggestion
boils down to "upgrade to 8.3.11". But if you're really trying to run a
version that's several years old, the best configuration advice you can
receive is to upgrade to something not totally prehistoric. There have been
major performance enhancements in each release since 7.3.7, and no amount of
hardware tuning will make such an old version perform comparatively well. Not
to mention the much greater risk you have that an unsupported version will eat
your data.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
Attachments:
signature.asc (application/pgp-signature, 196B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-05-25 14:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-25 14:04 tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
2010-05-25 14:27 ` Joshua Tolley <eggyknap@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox