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
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
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.