Re: Timestamps and performances problems - Mailing list pgsql-admin

On 10 Apr 2002 at 11:51, Gaetano Mendola wrote:

> "Jean-Christophe ARNU (JX)" <jc.arnu@free.fr> wrote:
> > Hello all.
> >   I've a performance problem on specific requests :
> >
> >   When I use timestamps + interval in where clauses, query performance is
> >  slowed down by a factor of 20 or 30!!!! For exemple :
> >   select timestamp,value
> >   from measure
> >   where timestamp<now() and timestamp>(now() - '1 hour'::interval)

Try where timestamp<now() and timestamp>(now() - '1
hour'::interval)::timestemp.

--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples