Re: Odd performance results - more info

>
> > Medora Schauer wrote:
> > > I would greatly appreciate it if someone could run this
> > code in their
> > > environment and let me know if you get results similiar to mine.
> > > The INT test results in execution times of 11 - 50+ secs
> increasing
> > > each time the test is run. The FLOAT test execution times are
> > > consistently < 3 secs regardless of how many times it is run.
> >
> > Without actually trying the code, I'd bet that an index is
> > getting used
> > for the float8 case, but not in the int8 case:
> >
>
> I've already verifed that the index is used in both cases.
>

I stand corrected. A sequential scan was being used in the INT8 case.
When I changed it to INT4 I got better results. I got confused cuz
I had changed the types so often.

Thanks for your help,

Medora