Re: Confirmation of bad query plan generated by 7.4 tree

From: "Marcin Mank" <marcin(dot)mank(at)gmail(dot)com>
To: "Shaun Thomas" <sthomas(at)leapfrogonline(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Confirmation of bad query plan generated by 7.4 tree
Date: 2006-06-13 18:17:46
Message-ID: 00af01c68f15$acd6eed0$0c67a8c0@maniek
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Browne 2006-06-13 18:22:06 Re: Which processor runs better for Postgresql?
Previous Message Tom Lane 2006-06-13 18:09:28 Re: Confirmation of bad query plan generated by 7.4 tree