Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Best way to index IP data?
- From: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Best way to index IP data?
- Date: Thu, 10 Jan 2008 16:14:54 -0700
Hi List; We'll be loading a table with begining & ending I.P.'s - the table will likely have upwards of 30million rows. Any thoughts on how to get the best performance out of queries that want to look for IP ranges or the use of between queries? Should these be modeled as integers? Thanks in advance /Kevin
- Follow-Ups:
- Re: Best way to index IP data?
- From: Steve Atkins
- Re: Best way to index IP data?
- From: Joshua D. Drake
- Re: Best way to index IP data?
- Prev by Date: Re: not exists clause
- Next by Date: Re: Best way to index IP data?
- Previous by thread: not exists clause
- Next by thread: Re: Best way to index IP data?
- Indexes: