Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) - Mailing list pgsql-performance

From Joshua Tolley
Subject Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)
Date
Msg-id 4bfbde38.d7b4e50a.4162.6ad1@mx.google.com
Whole thread Raw
In response to tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)  (Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>)
List 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

Attachment

pgsql-performance by date:

Previous
From: Juan Pablo Sandoval Rivera
Date:
Subject: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)
Next
From: Merlin Moncure
Date:
Subject: Re: Query timing increased from 3s to 55s when used as a function instead of select