Re: R-tree, order by, limit - Mailing list pgsql-general

On Sun, 21 Sep 2008, "Anton Belyaev" <anton.belyaev@gmail.com> 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.