X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A76E74763CE for ; Tue, 6 May 2003 08:21:30 -0400 (EDT) Received: from kernel.net.uy (ip129-2.bellsouth.net.uy [200.58.129.2]) by postgresql.org (Postfix) with SMTP id 3CB65476385 for ; Tue, 6 May 2003 08:21:28 -0400 (EDT) Received: (qmail 6684 invoked by uid 89); 6 May 2003 12:49:00 -0000 Received: from unknown (HELO fabio) (192.168.1.5) by 0 with SMTP; 6 May 2003 12:49:00 -0000 Reply-To: From: "Fabio C. Bon" To: Subject: A query with performance problems. Date: Tue, 6 May 2003 09:21:16 -0300 Message-ID: <003301c313c9$fe7a2d80$0501a8c0@kdomain> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Importance: Normal X-Spam-Status: No, hits=-3.1 required=5.0 tests=BAYES_20 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/55 X-Sequence-Number: 8617 Hi ! I have a database on PostgreSQL 7.2.1 and I have performance's problems with some queries. I'm debbuging the query below: Select count(*) from blcar where manide = 3811 and blide = 58090 and bcalupcod = 'MVDUY' and bcalopcod = 'LOCAL' and bcapag <> 'P';