Re: [PERFORM] gist indexes for distance calculations

2010-10-01 Thread Marcelo Zabani
Thanks a lot everyone for all the info! It is all really helpful. 2010/10/1 Merlin Moncure > On Thu, Sep 30, 2010 at 2:33 PM, Marcelo Zabani > wrote: > > Hi everyone. I have a question, and it's well beyond me to even speculate > > about the inner workings of postgr

Re: [PERFORM] gist indexes for distance calculations

2010-09-30 Thread Marcelo Zabani
So let me see if I understand, when searching for everyone within radius "r" of point (a,b), the gist index will be used like this: * C is the circle centered on (a,b) of radius "r" 1. Traverse down the tree, starting at the root. Only go down nodes whose bounding-box has a non-empty intersection

[PERFORM] gist indexes for distance calculations

2010-09-30 Thread Marcelo Zabani
ate,2))<=1; 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, Marcelo Zabani.