Re: slow inet within cidr query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: slow inet within cidr query
Дата
Msg-id 6510.1164748942@sss.pgh.pa.us
обсуждение исходный текст
Ответ на slow inet within cidr query  ("Edwin Grubbs" <edwin.grubbs@gmail.com>)
Список pgsql-general
"Edwin Grubbs" <edwin.grubbs@gmail.com> writes:
> Under postgres 8.1, the "<<=" comparison yields very slow queries with large
> tables.

<<= isn't optimizable within joins, and really isn't very suited to
btree indexes at all.  Sometime somebody should try to build a GiST
opclass that supports network sub/sup comparisons ... seems like it
should be pretty easy ...

            regards, tom lane

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

Предыдущее
От: Oisin Glynn
Дата:
Сообщение: Re: using a sequence as the functional equivalent to Oracle
Следующее
От: Ragnar
Дата:
Сообщение: Re: NULLs ;-)