IPv4 addresses, unsigned integers, space

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: IPv4 addresses, unsigned integers, space
Date: 2003-07-15 10:59:34
Message-ID: 87el0sgind.fsf@deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Does PostgreSQL already implement these data types? I don't think so.
If I succeed in implementing them, would you accept a patch?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Thomas 2003-07-15 12:23:30 Re: Are you frustrated with PostgreSQL
Previous Message Tony Grant 2003-07-15 10:45:52 Re: Are you frustrated with PostgreSQL