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

From Andrew Sullivan
Subject Re: Best way to index IP data?
Date
Msg-id 20080111222403.GA7527@crankycanuck.ca
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
On Fri, Jan 11, 2008 at 05:02:36PM -0500, Michael Stone wrote:

> networks), but there's a conspicuous lack of a type for (hosts). I
> suppose if you really are sure that you want to store hosts and not
> networks

Well, part of the trouble is that in the CIDR world, an IP without a netmask
can be dangerously ambiguous.  I can see why the design is as it is for that
reason.  (But I understand the problem.)

A


pgsql-performance by date:

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