Re: gist indexes for distance calculations - Mailing list pgsql-performance

From Robert Haas
Subject Re: gist indexes for distance calculations
Date
Msg-id AANLkTinru5HiozuVy2ayUjjJVpbtnpuWw69XcF+k3ewC@mail.gmail.com
Whole thread Raw
In response to Re: gist indexes for distance calculations  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-performance
On Fri, Oct 1, 2010 at 1:56 AM, Jesper Krogh <jesper@krogh.cc> wrote:
> On 2010-09-30 20:33, Marcelo Zabani wrote:
>>
>> If you can also pinpoint me to where I can find this sort of information
>> (index utilization and planning, performance tuning), I'd be very
>> grateful.
>> Thank you already,
>>
>
> Isn't this what the knngist patches are for?
> https://commitfest.postgresql.org/action/patch_view?id=350
>
> http://www.sai.msu.su/~megera/wiki/knngist

Those are for when you want to order by distance; the OP is trying to
*filter* by distance, which is different.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Slow count(*) again...
Next
From: Scott Carey
Date:
Subject: Re: Slow count(*) again...