Re: R-tree, order by, limit

From: Volkan YAZICI <yazicivo(at)ttmail(dot)com>
To: "Anton Belyaev" <anton(dot)belyaev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: R-tree, order by, limit
Date: 2008-09-22 10:30:01
Message-ID: 87prmwiic6.fsf@alamut.mobiliz.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 21 Sep 2008, "Anton Belyaev" <anton(dot)belyaev(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2008-09-22 10:39:11 Re: PDF Documentation for 8.3?
Previous Message Anton Belyaev 2008-09-22 10:18:08 Re: R-tree, order by, limit