On Sun, 21 Sep 2008, "Anton Belyaev" <[EMAIL PROTECTED]> writes: > And the questions about population remain the same: > How to avoid examination of all the towns in the rectangle knowing > that we need only 10 biggest? > Does population worth including into a (3D) point (In order to create > a 3D R-tree)? Does Postgres perform ODRER/LIMIT efficiently in this > case?
Can we see the EXPLAIN ANALYZE for both situations -- with and without geographic data types/functions? Regards. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
