X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5408852B28 for ; Thu, 11 Aug 2005 08:45:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82365-07 for ; Thu, 11 Aug 2005 11:44:58 +0000 (GMT) Received: from sentechsa.net (unknown [66.18.69.182]) by svr1.postgresql.org (Postfix) with ESMTP id 05C4152986 for ; Thu, 11 Aug 2005 08:44:54 -0300 (ADT) X-SpamCatcher-Score: 50 [XX] Received: from [194.179.55.34] (account indibil@webmail.co.za) by cgp7.sentechsa.net (CommuniGate Pro WebUser 4.3.5) with HTTP id 3595244 for pgsql-sql@postgresql.org; Thu, 11 Aug 2005 13:44:53 +0200 From: "Lucas Grijander" Subject: Select problems To: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro WebUser Interface v.4.3.5 Date: Thu, 11 Aug 2005 13:44:53 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.75 tagged_above=0 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376] X-Spam-Level: * X-Archive-Number: 200508/83 X-Sequence-Number: 22311 Hi: I've just migrated from Linux/PostgreSQL 7.2 to Windows/PostgreSQL 8.0.3. I have a large view. When I make: "Select ..... WHERE mydate = 'anydate'" the view lasts 19 seconds to complete. But, when I make: "Select ..... WHERE mydate >= 'anydate'" the view lasts 7 minutes. With PostgreSQL 7.2 they both last for equal time. I did a vacuum analyze with no success. Please, could you help me? Thanks in advance _________________________________________________________________ Need software for your hardware? Click here http://www.asg.co.za