Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DB0A99FA6B6 for ; Sat, 28 Jul 2007 20:07:25 -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 38963-09 for ; Sat, 28 Jul 2007 20:07:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hm32.locaweb.com.br (hm32-3.locaweb.com.br [200.234.205.225]) by postgresql.org (Postfix) with SMTP id B5C689FB1BA for ; Sat, 28 Jul 2007 20:07:22 -0300 (ADT) Received: (qmail 16320 invoked from network); 28 Jul 2007 23:07:19 -0000 Received: from unknown (10.1.10.142) by hm32.locaweb.com.br with QMQP; 28 Jul 2007 23:07:19 -0000 Received: from unknown (HELO brunolaptop) (bruno@ravnus.com@201.19.204.108) by hm456.locaweb.com.br with SMTP; 28 Jul 2007 23:07:39 -0000 From: "Bruno Rodrigues Siqueira" To: =?iso-8859-1?Q?'Herv=E9_Piedvache'?= , Subject: RES: select on 1milion register = 6s Date: Sat, 28 Jul 2007 20:07:18 -0300 Message-ID: <002f01c7d16c$0bf4e360$e900a8c0@brunolaptop> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcfRa8WW2OSuouTkSdOk45WsVGxxZQAADBSg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <200707282156.58418.bill.footcow@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.417 tagged_above=0 required=5 tests=AWL=1.416, BAYES_50=0.001 X-Spam-Level: * X-Archive-Number: 200707/409 X-Sequence-Number: 26093 Yes, i do. -----Mensagem original----- De: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] Em nome de Herv=E9 = Piedvache Enviada em: s=E1bado, 28 de julho de 2007 16:57 Para: pgsql-performance@postgresql.org Cc: Bruno Rodrigues Siqueira Assunto: Re: [PERFORM] select on 1milion register =3D 6s 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 --=20 Herv=E9 Piedvache ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match