Re: Help on indexing timestamps

On Fri, 07 Mar 2003 10:05:03 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Andre Schubert <andre@km3.de> writes:
> > Yes if i use BETWEEN and type in the dates by hand the query takes about 200ms with explain analyze.
> > I think these is a good performance.
> > But if i use now() instead of manually typed dates the query take about 1400ms :(
> > I thought the somebody posted to this list, that now() is a function that is not cached,
> > and thatswhy does not work pretty well with indexes.
> 
> Update to 7.3, and that problem will go away.
> 
What is the difference between 7.2 and 7.3 related to my problem ?

Thanks, as