X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2ABD1D1C509 for ; Sat, 2 Aug 2003 10:37:09 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 23070-01 for ; Sat, 2 Aug 2003 07:36:01 -0300 (ADT) Received: from smtp.noos.fr (nan-smtp-08.noos.net [212.198.2.77]) by svr1.postgresql.org (Postfix) with ESMTP id C4555D1C4E1 for ; Sat, 2 Aug 2003 07:37:06 -0300 (ADT) Received: (qmail 22408602 invoked by uid 0); 2 Aug 2003 10:37:07 -0000 Received: from unknown (HELO gmendola) ([212.198.37.110]) (envelope-sender ) by 212.198.2.77 (qmail-ldap-1.03) with SMTP for ; 2 Aug 2003 10:37:07 -0000 Message-ID: <005701c358e1$e4b52af0$10d4a8c0@mm.eutelsat.org> From: "Mendola Gaetano" To: Cc: "\"Fernando Papa\"" References: Subject: Re: I can't wait too much: Total runtime 432478.44 msec Date: Sat, 2 Aug 2003 12:36:12 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=REFERENCES X-Spam-Level: X-Archive-Number: 200308/21 X-Sequence-Number: 2838 From: ""Fernando Papa"" > AND upper(cont_publicacion.generar_Vainilla) = 'S' > Filter: ((upper((generar_vainilla)::text) = 'S'::text) AND (fecha_publicacion = (subplan))) using a functional index on this field should help create index idx_generar_vainilla_ci on cont_publicacion ( upper(generar_Vainilla) ) Regards Gaetano Mendola