Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Best way to index IP data?
- From: "Jonah H. 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: Thu, 10 Jan 2008 18:41:56 -0500
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/
- Follow-Ups:
- Re: Best way to index IP data?
- From: Pomarede Nicolas
- Re: Best way to index IP data?
- References:
- Best way to index IP data?
- From: Kevin Kempter
- Re: Best way to index IP data?
- From: Steve Atkins
- Best way to index IP data?
- Prev by Date: Re: Best way to index IP data?
- Next by Date: Re: not exists clause
- Previous by thread: Re: Best way to index IP data?
- Next by thread: Re: Best way to index IP data?
- Indexes: