> 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. Medora ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html