Re: IPv4 addresses, unsigned integers, space

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: IPv4 addresses, unsigned integers, space
Дата
Msg-id 87k7ah7alo.fsf@deneb.enyo.de
обсуждение исходный текст
Ответ на Re: IPv4 addresses, unsigned integers, space  (Jim Crate <jcrate@deepskytech.com>)
Список pgsql-general
Jim Crate <jcrate@deepskytech.com> writes:

> on 7/15/03, Florian Weimer <fw@deneb.enyo.de> wrote:
>
>>If I switched from signed integers to unsigned integers (and from INET
>>to "real" IPv4 addresses, consisting of the relevant 32 bits only) I
>>think I could save about 25% of my table size.
>
> Why do you need unsigned ints to hold IP addresses?

This is a misunderstanding.  I could use both space-conservative IP
addresses and unsigned integers.

> What difference does it make if IP addresses with a class A higher
> than 127 appear as negative numbers?

The mapping does not preserve ordering if not done carefully.

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

Предыдущее
От: Annabelle Desbois
Дата:
Сообщение: Re: ERROR: current transaction is aborted, queries ignored
Следующее
От: jerome
Дата:
Сообщение: Cache Query..