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 20080111213204.GV5294@mathom.us
Whole thread Raw
In response to Re: Best way to index IP data?  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Responses Re: Best way to index IP data?  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-performance
On Fri, Jan 11, 2008 at 03:19:35PM -0500, D'Arcy J.M. Cain wrote:
>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.

And, there are many cases where you don't. I've got two kinds of db's
that have IPs in them. In some, the IP is a small part of a table which
is focused on something else. For those I use inet, which provides a
nice bit of future-proofing. In other db's the IPs are the primary
focus. There are lots and lots of IPs, and the space used by IPs may be
the largest chunk of a particular table. For those tables, I don't use
inet because the overhead really is a significant fraction of the space.

Mike Stone

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: Best way to index IP data?
Next
From: Alvaro Herrera
Date:
Subject: Re: Best way to index IP data?