Postgres Pro
Downloads
Home   >   mailing lists

Re: Confirmation of bad query plan generated by 7.4 tree - Mailing list pgsql-performance

From Marcin Mank
Subject Re: Confirmation of bad query plan generated by 7.4 tree
Date
Msg-id 00af01c68f15$acd6eed0$0c67a8c0@maniek
Whole thread Raw
In response to Confirmation of bad query plan generated by 7.4 tree  ("Shaun Thomas" <sthomas@leapfrogonline.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Confirmation of bad query plan generated by 7.4 tree
Next
From: Scott Marlowe
Date:
Subject: Re: Which processor runs better for Postgresql?