Re: Best way to index IP data?

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Steve Atkins" <steve(at)blighty(dot)com>
Cc: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Best way to index IP data?
Date: 2008-01-10 23:41:56
Message-ID: 36e682920801101541o7626bbddj428617144240c554@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Jan 10, 2008 6:25 PM, Steve Atkins <steve(at)blighty(dot)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(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guy Rouillier 2008-01-11 04:00:23 Re: not exists clause
Previous Message Steve Atkins 2008-01-10 23:25:20 Re: Best way to index IP data?