Re: IP addresses

From: Steve Atkins <steve(at)blighty(dot)com>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: IP addresses
Date: 2007-11-20 23:54:38
Message-ID: B1E67A53-678D-4817-9C14-F9236E087184@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Nov 20, 2007, at 3:41 PM, Tom Lane wrote:

> "Sander Steffann" <s(dot)steffann(at)computel(dot)nl> writes:
>> From: "Harald Fuchs" <hf0217x(at)protecting(dot)net>
>>> Forget inet. Check out http://pgfoundry.org/projects/ip4r/ and
>>> be happy.
>
>> I would be happy if it would support IPv6 :-) Are there plans to
>> make ip6r
>> or something like that?
>
> What's the point? You might as well use the regular inet type if you
> need to handle ipv6.

ip4r's main advantage over inet is that it allows you to answer
the question "is this IP address in any of these large number of
address ranges" efficiently. It's useful for customer address
allocation, email filtering blacklists, things like that.

A range-indexable ipv6 type would be useful in theory, but I've
not seen a need for it in production yet. When there is, extending
ip4r to become ip6r would be possible.

Cheers,
Steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2007-11-21 00:14:07 Re: Calculation for Max_FSM_pages : Any rules of thumb?
Previous Message Tom Lane 2007-11-20 23:41:58 Re: IP addresses