On Fri, Oct 1, 2010 at 1:56 AM, Jesper Krogh <jesper@xxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
