Re: Best way to index IP data? - Mailing list pgsql-performance

From Michael Stone
Subject Re: Best way to index IP data?
Date
Msg-id 20080111212703.GU5294@mathom.us
Whole thread Raw
In response to Re: Best way to index IP data?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Best way to index IP data?
Re: Best way to index IP data?
List pgsql-performance
On Fri, Jan 11, 2008 at 03:07:38PM -0500, Tom Lane wrote:
>Michael Stone <mstone+postgres@mathom.us> writes:
>> Well, a native IPv6 type would also be nice; inet is ridiculously
>> bloated for both IPv4 *and* IPv6.
>
>Nonsense.  3 bytes overhead on a 16-byte address is not "ridiculously
>bloated", especially if you want a netmask with it.

Big if, no? There's a very large set of users that *don't* want/need a
netmask, which is why the topic keeps coming back. (Also, according to
the docs, inet requires 24 bytes, which is 50% more than needed; is that
not correct?)

Mike Stone

pgsql-performance by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Best way to index IP data?
Next
From: Michael Stone
Date:
Subject: Re: Best way to index IP data?