> 
> > 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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to