Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id CCA7E632E20 for ; Tue, 25 May 2010 11:27:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 93525-05 for ; Tue, 25 May 2010 14:27:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 0993F632DFC for ; Tue, 25 May 2010 11:27:08 -0300 (ADT) Received: by gyg13 with SMTP id 13so2003044gyg.19 for ; Tue, 25 May 2010 07:27:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:cc :subject:references:mime-version:content-type:content-disposition :in-reply-to:user-agent; bh=ToJipk5JMw+ybxjM5NtH18g1lmPhYGvYEjIbwXasIjc=; b=jnvfl8EwOHl/SO1BG01zItCoaEaoQyUcqEftmYMaTQusOqApzZoOhUagEgqH0NRx35 1rkUORgK4+NzteHH416MZDyofeRQqab51eyZGVZcr8gtGL96ncpN+uIt2krOLI1HHCLs wEkvy+RzS1D5VTvtPhIrmIhr7CExq9yo6d8h8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:cc:subject:references:mime-version :content-type:content-disposition:in-reply-to:user-agent; b=ZgeFVQGRuISIfWDauSEZO0mFmLEumcvIL8LbjkqX81U4teMPUxhTEqgfjvRxzvFIP1 Ul6h214lAAyxHcrRD1JZXEC9Jyrs/wIb+EcIVJBJc7jF1jqRJqIb9HyG70teCMuQY/J0 mPw5oyzZwQeymT3kWNNphris+YG42GHDZiado= Received: by 10.229.230.202 with SMTP id jn10mr1449651qcb.166.1274797625434; Tue, 25 May 2010 07:27:05 -0700 (PDT) Received: from eddie (c-67-182-224-31.hsd1.ut.comcast.net [67.182.224.31]) by mx.google.com with ESMTPS id bv23sm1251456qcb.13.2010.05.25.07.27.03 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 25 May 2010 07:27:04 -0700 (PDT) Message-ID: <4bfbde38.d7b4e50a.4162.6ad1@mx.google.com> Date: Tue, 25 May 2010 08:27:01 -0600 From: Joshua Tolley To: Juan Pablo Sandoval Rivera Cc: pgsql-performance@postgresql.org Subject: Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) References: <20100525140415.457ED6321D3@mail.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="kfjH4zxOES6UT95V" Content-Disposition: inline In-Reply-To: <20100525140415.457ED6321D3@mail.postgresql.org> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_20=-0.001 X-Spam-Level: X-Archive-Number: 201005/178 X-Sequence-Number: 38762 --kfjH4zxOES6UT95V Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 --kfjH4zxOES6UT95V Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkv73jUACgkQRiRfCGf1UMMM0QCfUKDx9kAu/kWf4HvZEd4yAdOc 9V0AnRRNJc7Iux19L7f3FjXVm1EEnv1O =v8Tj -----END PGP SIGNATURE----- --kfjH4zxOES6UT95V--