I'll wait for the proof I think. Just now starting to work with POSTGIS, and historically, large datasets have worked faster (for me) for this type of query when worked against a tabular numeric column. If speed of return is the primary constraint . . . I'll gladly jump on the wagon that this is not so with POSTGIS. I don't have a 21 million record dataset to test with however. :c) bobb >>> "Mr. Puneet Kishor" <punk.k...@gmail.com> wrote: On Mar 7, 2012, at 11:36 AM, Bob Basques wrote: > if (x > minx && x < max && y > miny && y < maxy) then true. . This is precisely the kind of problem that GiST solves. The above query is not likely to be better than a spatial query. -- Puneet Kishor _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
