Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 36CB09FB9F5
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 28 Mar 2007 10:24:53 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 95285-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 28 Mar 2007 10:24:44 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174])
	by postgresql.org (Postfix) with ESMTP id 98C969FB89E
	for <pgsql-performance@postgresql.org>;
	Wed, 28 Mar 2007 10:24:44 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id k3so187201ugf
	for <pgsql-performance@postgresql.org>;
	Wed, 28 Mar 2007 06:24:42 -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:content-transfer-encoding:content-disposition:references;
	b=lOpkgQzeah8waMx7p5QNyJcx1vd0VNEdpgAETNJVE7j/Qj7bycZVgmxMb+ugYs9C67MSCcFjvlOBTQpKU4XhimTT4nmmuzFnDsUw6w+LBjZWl1hq/+tthSGp/dLwZoVW9SffNFku0xgyZE0hFby+tawsnlWlI09iJzmioMOAkD4=
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:content-transfer-encoding:content-disposition:references;
	b=nXifip7FE5snC0SkFw05lf5I3iszfK1KFgCWft2eABokoBhy2Df/sMgwT/6YM6ZwFpjwnJVwTRsv0/g1kHnYDATYeA1IYBxBGxM8z06cJ5t0hzpFK0w3hcQ3R7e7DIpp3lrW0vOpNJbxDFHU6V3QX0LUGEGkysLyhNubSUNKmRQ=
Received: by 10.114.171.1 with SMTP id t1mr3698180wae.1175088281727;
	Wed, 28 Mar 2007 06:24:41 -0700 (PDT)
Received: by 10.114.158.12 with HTTP; Wed, 28 Mar 2007 06:24:41 -0700 (PDT)
Message-ID: <3c1395330703280624h19840e7ei883fa196a917c856@mail.gmail.com>
Date: Wed, 28 Mar 2007 23:24:41 +1000
From: "chris smith" <dmagick@gmail.com>
To: "Daniel Cristian Cruz" <danielcristian@gmail.com>
Subject: Re: Improving performance on system catalog
Cc: pgsql-performance@postgresql.org
In-Reply-To: <48d0cacb0703280559g50610f2r67f189bec4185b73@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <48d0cacb0703280559g50610f2r67f189bec4185b73@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/409
X-Sequence-Number: 23814

> I would like to speed up this query:

<snip>

>  Total runtime: 13.844 ms

Why bother?

It's running in less than 14 milliseconds.

-- 
Postgresql & php tutorials
http://www.designmagick.com/