On 25 Feb 2002, Doug McNaught wrote:
> "Thomas T. Thai" <tom@minnesota.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.