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

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Juan Pablo Sandoval Rivera <juapabsan(at)tutopia(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp)
Date: 2010-05-25 14:27:01
Message-ID: 4bfbde38.d7b4e50a.4162.6ad1@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

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