Re: R-tree, order by, limit

Поиск
Список
Период
Сортировка
От Volkan YAZICI
Тема Re: R-tree, order by, limit
Дата
Msg-id 87prmwiic6.fsf@alamut.mobiliz.com.tr
обсуждение исходный текст
Ответ на Re: R-tree, order by, limit  ("Anton Belyaev" <anton.belyaev@gmail.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Anton Belyaev"
Дата:
Сообщение: Re: R-tree, order by, limit
Следующее
От: Sam Mason
Дата:
Сообщение: Re: PDF Documentation for 8.3?