THAT WAS IT!!
Thank you very much.
Is there a way to change the type of "CURRENT_TIMESTAMP" to "timestamp
without time zone" so that casting isn't needed?
BTW, isn't this a bug?
Stephan Szabo wrote:
>On Mon, 26 Jul 2004, Harmon S. Nine wrote:
>>However, we can't get the planner to do an timestamp-based index scan.
>>Anyone know what to do?
>I'd wonder if the type conversion is causing you problems.
>CURRENT_TIMESTAMP - INTERVAL '10 minutes' is a timestamp with time zone
>while the column is timestamp without time zone. Casting
>CURRENT_TIMESTAMP to timestamp without time zone seemed to make it able to
>choose an index scan on 7.4.
In response to
pgsql-performance by date
|Next:||From: Ross J. Reedstrom||Date: 2004-07-26 18:47:03|
|Subject: Re: arrays and indexes|
|Previous:||From: Scott Marlowe||Date: 2004-07-26 16:25:38|
|Subject: Re: Insert are going slower ...|