X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CA72ED791E for ; Fri, 2 Sep 2005 19:56:08 -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 96834-06 for ; Fri, 2 Sep 2005 22:56:05 +0000 (GMT) Received: from r163ip.btv.lv (r163ip.btv.lv [217.198.224.163]) by svr1.postgresql.org (Postfix) with ESMTP id 26DC0D8A5C for ; Fri, 2 Sep 2005 19:56:02 -0300 (ADT) Received: from p4 (pIV.homenet [192.168.88.4]) by r163ip.btv.lv (8.12.9/8.12.6) with ESMTP id j82Mu2p6004594 for ; Sat, 3 Sep 2005 01:56:04 +0300 (EEST) (envelope-from postgres@bilteks.com) From: "Alexander Kirpa" To: pgsql-performance@postgresql.org Date: Sat, 3 Sep 2005 01:56:03 +0300 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Poor SQL performance Message-ID: <431902B3.24869.16B01310@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/74 X-Sequence-Number: 14382 Place 'and date(r.site_timestamp) = h.first_order_date' after WHERE Best regards, Alexander Kirpa