Re: help with getting index scan

On 25 Feb 2002, Doug McNaught wrote:

> "Thomas T. Thai" <tom(at)minnesota(dot)com> writes:
>
> > i just tried turning off seq scan and the query still takes up to 8
> > seconds which is 7 seconds too long. btw, how do you clean the cache
> > from the last query?
>
> I took a detailed look at your schema and I'm not enough of a guru to
> offer any more advice (I've never used gist indexes or anything like
> that). Maybe Tom or someone with more knowledge than I will weigh
> in.

oh don't worry about the gist index. that is actually really fast.

> The only way I know of to "clear the cache" is to restart the
> database.

ouch. lol. cause when i try to time the same query again, the cached time
isn't what i want.

thanks though doug.