Re: Help on indexing timestamps

On Fri, 07 Mar 2003 10:05:03 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Andre Schubert <andre(at)km3(dot)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