Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E04289FB8CB for ; Wed, 28 Mar 2007 14:08:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 84977-04 for ; Wed, 28 Mar 2007 14:08:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id 41F079FB707 for ; Wed, 28 Mar 2007 14:08:29 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id r28so2341055nza for ; Wed, 28 Mar 2007 10:08:28 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=dXb4ZPfo5uu2To7C9a+iKwMbZGPI5FTXcw8+p/hmEsUT5ScNfMq/TVogJc864eMegP8tvlqEhsgh6DcYZ0uRjRO8K1sgj69iMdB69S0KemUhnNlm8Ek/w4N1PtCYSowG6mxSiyXFruzGGFtSPAWkLIAL4ZXkBOqB9m1ZO+04W7A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=shwICgWGpy9+W+SdePQ9IEneVyc7Zfx3kW9P1/r6rHrTRBBT/LP5aGpcdHOrzrlStf3DPJ2AHjwHji8/u5cUgNLtCpXdK848fMb7BKoHSqZigTazZeKekM4w9A6mZpJI4iQnWBlAnUdT5UEPI1dnGMoMHmqQv1CXWEreBL4ZNAM= Received: by 10.115.108.1 with SMTP id k1mr3832283wam.1175101707691; Wed, 28 Mar 2007 10:08:27 -0700 (PDT) Received: by 10.115.72.5 with HTTP; Wed, 28 Mar 2007 10:08:27 -0700 (PDT) Message-ID: <48d0cacb0703281008q3f9befabp796f99ef15201423@mail.gmail.com> Date: Wed, 28 Mar 2007 14:08:27 -0300 From: "Daniel Cristian Cruz" To: "Tom Lane" Subject: Re: Improving performance on system catalog Cc: pgsql-performance@postgresql.org In-Reply-To: <2637.1175099302@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_38486_22091833.1175101707618" References: <48d0cacb0703280559g50610f2r67f189bec4185b73@mail.gmail.com> <3c1395330703280624h19840e7ei883fa196a917c856@mail.gmail.com> <48d0cacb0703280852i120c2bfdp552d1c53904cf273@mail.gmail.com> <2637.1175099302@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/413 X-Sequence-Number: 23818 ------=_Part_38486_22091833.1175101707618 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 2007/3/28, Tom Lane : > > "Daniel Cristian Cruz" writes: > > 2007/3/28, chris smith : > >>> Total runtime: 13.844 ms > >> > >> Why bother? > > > Because faster could be better in a very busy system. > > If you are concerned about global performance improvement, quit worrying > about this micro-detail and get yourself onto a more modern Postgres. Got it. We just planned move to 8.2.3 in about two weeks. -- Daniel Cristian Cruz Analista de Sistemas ------=_Part_38486_22091833.1175101707618 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 2007/3/28, Tom Lane <tgl@sss.pgh.pa.us>:
"Daniel Cristian Cruz" <danielcristian@gmail.com> writes:
> 2007/3/28, chris smith <dmagick@gmail.com>:
>>> Total runtime: 13.844 ms
>>
>> Why bother?

> Because faster could be better in a very busy system.

If you are concerned about global performance improvement, quit worrying
about this micro-detail and get yourself onto a more modern Postgres.

Got it. We just planned move to  8.2.3 in about two weeks.

--
Daniel Cristian Cruz
Analista de Sistemas ------=_Part_38486_22091833.1175101707618--