Postgres Pro
Downloads
Home   >   mailing lists

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

From Florian Weimer
Subject IPv4 addresses, unsigned integers, space
Date
Msg-id 87el0sgind.fsf@deneb.enyo.de
Whole thread Raw
Responses Re: IPv4 addresses, unsigned integers, space  (Bruno Wolff III <bruno@wolff.to>)
Re: IPv4 addresses, unsigned integers, space  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: IPv4 addresses, unsigned integers, space  (Jim Crate <jcrate@deepskytech.com>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: Re: Are you frustrated with PostgreSQL
Next
From: Paul Thomas
Date:
Subject: Re: Are you frustrated with PostgreSQL