Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Best way to index IP data?
Date
Msg-id 24044.1200082058@sss.pgh.pa.us
Whole thread Raw
In response to Re: Best way to index IP data?  (Michael Stone <mstone+postgres@mathom.us>)
Responses Re: Best way to index IP data?
Re: Best way to index IP data?
List pgsql-performance
Tree view 
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.

            regards, tom lane

pgsql-performance by date:

Previous
From: Jörg Kiegeland
Date:
Subject: Re: Evaluating boolean formula: slow performance
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Best way to index IP data?