Re: IPv4 addresses, unsigned integers, space

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: Jim Crate <jcrate(at)deepskytech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: IPv4 addresses, unsigned integers, space
Date: 2003-07-17 09:42:43
Message-ID: 87k7ah7alo.fsf@deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jim Crate <jcrate(at)deepskytech(dot)com> writes:

> on 7/15/03, Florian Weimer <fw(at)deneb(dot)enyo(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-07-17 11:01:20 Re: Cache Query..
Previous Message jack 2003-07-17 08:41:17 question about pgsqlODBC down load