Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Best way to index IP data?



On Fri, 11 Jan 2008 15:07:38 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Michael Stone <mstone+postgres(at)mathom(dot)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.

Besides, there are many cases where you want to track both ipv4 and
ipv6 for the same purpose and requiring two different fields would be
less than ideal.

-- 
D'Arcy J.M. Cain <darcy(at)druid(dot)net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group