Postgres Pro
Downloads
Home   >   mailing lists

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

From Jonah H. Harris
Subject Re: Best way to index IP data?
Date
Msg-id 36e682920801101541o7626bbddj428617144240c554@mail.gmail.com
Whole thread Raw
In response to Re: Best way to index IP data?  (Steve Atkins <steve@blighty.com>)
Responses Re: Best way to index IP data?
List pgsql-performance
Tree view 
On Jan 10, 2008 6:25 PM, Steve Atkins <steve@blighty.com> wrote:
> http://pgfoundry.org/projects/ip4r/
>
> That has the advantage over using integers, or the built-in inet type,
> of being indexable for range and overlap queries.

Agreed.  ip4r is da bomb.

--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation                | fax: 732.331.1301
499 Thornall Street, 2nd Floor          | jonah.harris@enterprisedb.com
Edison, NJ 08837                        | http://www.enterprisedb.com/

pgsql-performance by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Best way to index IP data?
Next
From: Guy Rouillier
Date:
Subject: Re: not exists clause