Re: Best way to index IP data?

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: Best way to index IP data?
Дата
Msg-id 20080111212703.GU5294@mathom.us
обсуждение исходный текст
Ответ на Re: Best way to index IP data?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Best way to index IP data?  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Best way to index IP data?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Fri, Jan 11, 2008 at 03:07:38PM -0500, Tom Lane wrote:
>Michael Stone <mstone+postgres@mathom.us> writes:
>> Well, a native IPv6 type would also be nice; inet is ridiculously
>> bloated for both IPv4 *and* IPv6.
>
>Nonsense.  3 bytes overhead on a 16-byte address is not "ridiculously
>bloated", especially if you want a netmask with it.

Big if, no? There's a very large set of users that *don't* want/need a
netmask, which is why the topic keeps coming back. (Also, according to
the docs, inet requires 24 bytes, which is 50% more than needed; is that
not correct?)

Mike Stone

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

Предыдущее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: Best way to index IP data?
Следующее
От: Michael Stone
Дата:
Сообщение: Re: Best way to index IP data?