Re: Help optimizing a slow index scan

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Help optimizing a slow index scan
Дата
Msg-id b42b73150603171007h4de1a9f2g8523bda08f392258@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Help optimizing a slow index scan  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-performance
On 3/17/06, Bruno Wolff III <bruno@wolff.to> wrote:
> Have you looked at using the Earth Distance contrib module? If a spherical
> model of the earth is suitable for your application, then it may work for you
> and might be easier than trying to create Gist indexes yourself.

earth distance = great stuff.  If the maximum error is known then you
can just pad the distance and filter the result on the client if exact
precision is needed.

Merlin

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

Предыдущее
От: 11
Дата:
Сообщение: Re: Background writer configuration
Следующее
От: Evgeny Gridasov
Дата:
Сообщение: Re: Background writer configuration