Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group