Re: index for inet column

Поиск
Список
Период
Сортировка
От Christoph Moench-Tegeder
Тема Re: index for inet column
Дата
Msg-id YsdY09CGh4T2uMPF@elch.exwg.net
обсуждение исходный текст
Ответ на index for inet column  (Zhihong Yu <zyu@yugabyte.com>)
Список pgsql-hackers
## Zhihong Yu (zyu@yugabyte.com):

> I was able to create gin index on inet column in PG.
> 
> GIN is good with points/elements in sets. Is gin a good index for inet
> column ?
> It seems gist index would be better.

Why not use btree? The common operations are quite supported with that.
(Common operations being equality and subnet/CIDR matching, the latter
being a glorified less/greater than operation. If you are using non-
continous netmasks, you are already in a rather painful situation
networkwise and it will not get better in the database, so don't).

Regards,
Christoph

-- 
Spare Space



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

Предыдущее
От: Zhihong Yu
Дата:
Сообщение: index for inet column
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: remove more archiving overhead