Postgres Pro
Downloads
Home   >   mailing lists

Re: Index scan vs. Seq scan on timestamps - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Index scan vs. Seq scan on timestamps
Date
Msg-id 20041206183201.B61668@megazone.bigpanda.com
Whole thread Raw
In response to Index scan vs. Seq scan on timestamps  (Per Jensen <per@net-es.dk>)
Responses Re: Index scan vs. Seq scan on timestamps
List pgsql-general
Tree view 
On Mon, 6 Dec 2004, Per Jensen wrote:

> select count(*)
> from accesslog
> where time  between (timeofday()::timestamp - INTERVAL '30 d') and
> timeofday()::timestamp;

Besides the type issue, timeofday() is volatile and thus is not allowed to
be turned into a constant in order to do an index scan because it's
allowed to return different values for every row of the input.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: hooks for supporting third party blobs?
Next
From: Stephen Frost
Date:
Subject: Re: Index scan vs. Seq scan on timestamps