Re: IPv4 addresses, unsigned integers, space - Mailing list pgsql-general

From Florian Weimer
Subject Re: IPv4 addresses, unsigned integers, space
Date
Msg-id 87k7ah7alo.fsf@deneb.enyo.de
Whole thread Raw
In response to Re: IPv4 addresses, unsigned integers, space  (Jim Crate <jcrate@deepskytech.com>)
List 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 by date:

Previous
From: Annabelle Desbois
Date:
Subject: Re: ERROR: current transaction is aborted, queries ignored
Next
From: jerome
Date:
Subject: Cache Query..