Re: Confirmation of bad query plan generated by 7.4 tree

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Shaun Thomas" <sthomas@xxxxxxxxxxxxxxxxxx>, <pgsql-performance@xxxxxxxxxxxxxx>
Subject: Re: Confirmation of bad query plan generated by 7.4 tree
From: "Marcin Mank" <marcin.mank@xxxxxxxxx>
Date: Tue, 13 Jun 2006 20:17:46 +0200
References: <448EB053.8F27.00A9.0@xxxxxxxxxxxxxxxxxx>

> 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

References:
- Confirmation of bad query plan generated by 7.4 tree
  - From: Shaun Thomas

Prev by Date: Re: Confirmation of bad query plan generated by 7.4 tree
Next by Date: Re: Which processor runs better for Postgresql?
Previous by thread: Re: Confirmation of bad query plan generated by 7.4
Next by thread: Which processor runs better for Postgresql?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux