On Jan 10, 2008, at 3:14 PM, Kevin Kempter wrote:
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?
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.
Cheers,
Steve
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
