X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C86A49FA13E for ; Tue, 13 Jun 2006 15:17:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 06852-10 for ; Tue, 13 Jun 2006 15:17:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 224769F9316 for ; Tue, 13 Jun 2006 15:17:31 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so2373946ugc for ; Tue, 13 Jun 2006 11:17:30 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:references:subject:date:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=Vw8S9XGONkju9/6Rujm+/8DcP+2Cz4ZVLIlMLsAiSAs/rabB3favsytf/uVGYUava1XmoOT+KJGD5gcZg+6JGJAWTigbCHt5icjxu2HyIN//lzIhPy7pX/uFgeTA2Qzijr0tvjU45NzaAxWrD8Qj7hZKrZK7uyWWSLwFhUudbTo= Received: by 10.67.97.7 with SMTP id z7mr6509492ugl; Tue, 13 Jun 2006 11:17:30 -0700 (PDT) Received: from maniek ( [62.148.95.123]) by mx.gmail.com with ESMTP id s1sm7876280uge.2006.06.13.11.17.29; Tue, 13 Jun 2006 11:17:30 -0700 (PDT) Message-ID: <00af01c68f15$acd6eed0$0c67a8c0@maniek> From: "Marcin Mank" To: "Shaun Thomas" , References: <448EB053.8F27.00A9.0@leapfrogonline.com> Subject: Re: Confirmation of bad query plan generated by 7.4 tree Date: Tue, 13 Jun 2006 20:17:46 +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.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/191 X-Sequence-Number: 19548 > warehouse-# WHERE e.event_date > now() - interval '2 days' Try explicitly querying: WHERE e.event_date > '2006-06-11 20:15:00' In my understanding 7.4 does not precalculate this timestamp value for the purpose of choosing a plan. Greetings Marcin