Re: help with getting index scan

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.

In response to

Browse pgsql-general by date

  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