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: 2008-01-10 23:14:54
Message-ID: 200801101614.54729.kevin@kevinkempterllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2008-01-10 23:22:45 Re: Best way to index IP data?
Previous Message Josh Berkus 2008-01-10 21:50:30 Re: not exists clause