From: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
---|---|
To: | Doug McNaught <doug(at)wireboard(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: help with getting index scan |
Date: | 2002-02-25 16:48:02 |
Message-ID: | Pine.NEB.4.43.0202251046150.27000-100000@ns01.minnesota.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-02-25 16:50:10 | Re: help with getting index scan |
Previous Message | Doug McNaught | 2002-02-25 16:41:03 | Re: help with getting index scan |