Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 954F69FB528
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sat, 28 Jul 2007 16:57:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 67386-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sat, 28 Jul 2007 16:57:04 -0300 (ADT)
X-Greylist: whitelisted by SQLgrey-1.7.5
Received: from smtp8-g19.free.fr (smtp8-g19.free.fr [212.27.42.65])
	by postgresql.org (Postfix) with ESMTP id 589119FB5A6
	for <pgsql-performance@postgresql.org>;
	Sat, 28 Jul 2007 16:57:07 -0300 (ADT)
Received: from smtp8-g19.free.fr (localhost [127.0.0.1])
	by smtp8-g19.free.fr (Postfix) with ESMTP id E7D511CD3B;
	Sat, 28 Jul 2007 21:57:05 +0200 (CEST)
Received: from zoot.local (tru75-6-82-240-32-109.fbx.proxad.net
	[82.240.32.109])
	by smtp8-g19.free.fr (Postfix) with ESMTP id C4ABD1CD6E;
	Sat, 28 Jul 2007 21:57:04 +0200 (CEST)
From: =?iso-8859-1?q?Herv=E9_Piedvache?= <bill.footcow@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: select on 1milion register = 6s
Date: Sat, 28 Jul 2007 21:56:58 +0200
User-Agent: KMail/1.9.6
Cc: "Bruno Rodrigues Siqueira" <bruno@ravnus.com>
References: <000c01c7d14d$4df223f0$e900a8c0@brunolaptop>
In-Reply-To: <000c01c7d14d$4df223f0$e900a8c0@brunolaptop>
X-Face: Q~R=,(z%>18cais1AC25|#(q>ihP; 4[0^5ZM!|rrF`;
	J\<uf`h3bNr"/qZ4?N["KONmE@=?utf-8?q?=27=0A=09KV=7B=3BH4m?=)q5gYF>cq%{ei$`jaEfrxkS9NtP{X'KUd]\gZGcj3#r|*.[;
	@'w}feV"=?utf-8?q?=607=607j=60=7E=0A=09f7=7EF?=){$[oAPG)?M2ro}dZKHoYd8P?1JTUr$>6@G0yQV<YmA5zd{ZY&7P&1P[yE(=?utf-8?q?=5B*Y-4QB=0A=09OJ*dTN=7CWz!=25?=>9Y\FNpONS+i.Y1M{=eAFuJo6.}6d-k:zp+_*@/mec@(<=?utf-8?q?=5B=26*aFBsp*FRX8=24=0A=09=27czo-6h=23kce+f?=(Z?KlRecYCEEb,vA{Lq
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200707282156.58418.bill.footcow@gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200707/400
X-Sequence-Number: 26084

Do you have analyzed your table before doing this ?

Le samedi 28 juillet 2007, Bruno Rodrigues Siqueira a =E9crit :
> Friends,
>
>
>
>
>
>
>
>             Who can help me? My SELECT in a base with 1 milion register,
> using  expression index =3D 6seconds.
>
>
>
>
>
> Please, I don't  know how to makes it better.
>
>
>
>
>
> Thanks



=2D-=20
Herv=E9 Piedvache