Re: Timestamp-based indexing

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Harmon S(dot) Nine" <hnine(at)netarx(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Timestamp-based indexing
Date: 2004-07-26 16:02:03
Message-ID: 20040726085324.E68237@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2004-07-26 16:25:38 Re: Insert are going slower ...
Previous Message Tom Lane 2004-07-26 15:59:11 Re: Timestamp-based indexing