Mark Stosberg wrote: > > I'm reading the explain analyze output correctly myself, nearly all of > the time spent is related to the 'pets' table, but I can't see what to > about it. Something about typing that message jarred by brain to think to try: VACUUM FULL pets; VACUUM ANALYZE pets; Now the new cube-based calculation benchmarks reliably faster. The old lat/lon systems now benchmarks at 250ms, while the the new cube-based code bechmarks at 100ms, over a 50% savings! That's good enough for me. However, I'm still interested advice on the other points I snuck into my last message about joining with ints vs varchars and best use of partial indexes. Mark
