X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8C7179DC888 for ; Mon, 20 Mar 2006 12:34:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14474-04 for ; Mon, 20 Mar 2006 12:34:54 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3220E9DC8E1 for ; Mon, 20 Mar 2006 12:34:54 -0400 (AST) Received: from linares.terra.com.br (linares.terra.com.br [200.176.10.195]) by svr4.postgresql.org (Postfix) with ESMTP id D1EE45AF195 for ; Mon, 20 Mar 2006 16:34:53 +0000 (GMT) Received: from moroto.terra.com.br (moroto.terra.com.br [200.176.10.5]) by linares.terra.com.br (Postfix) with ESMTP id 0977C4DC0D8 for ; Mon, 20 Mar 2006 13:34:48 -0300 (BRT) X-Terra-Karma: -2% X-Terra-Hash: a512f1d9e3549e0aa3dd0b84135014c3 Received-SPF: pass (moroto.terra.com.br: domain of terra.com.br designates 200.176.10.5 as permitted sender) client-ip=200.176.10.5; envelope-from=carlosreimer@terra.com.br; helo=reimer; Received: from reimer (201-3-253-69.bnut3702.dsl.brasiltelecom.net.br [201.3.253.69]) (authenticated user carlosreimer) by moroto.terra.com.br (Postfix) with ESMTP id C0B3614CC482 for ; Mon, 20 Mar 2006 13:34:47 -0300 (BRT) Message-ID: <001301c64c3c$3404b3f0$8b00000a@reimer> From: "Reimer" To: References: <441EC34D.1000901@bluestudio.it> Subject: Re: Query Feromance Date: Mon, 20 Mar 2006 13:34:47 -0300 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.919 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.919 X-Spam-Level: * X-Archive-Number: 200603/335 X-Sequence-Number: 17772 Marco, Could you give us the query you would like to improve performance? ----- Original Message ----- From: "Marco Furetto" To: Sent: Monday, March 20, 2006 11:59 AM Subject: [PERFORM] Query Feromance > Hello! > > Can I Increment the perfomance of execution query? > > Where is the instrument to analyze the query runnnig for create a Index > query for a single optimize that? > > thank's > > Marco "Furetto" Berri > > ---------------------------(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 >