Postgres Pro
Downloads
Home   >   mailing lists

Best way to index IP data? - Mailing list pgsql-performance

From Kevin Kempter
Subject Best way to index IP data?
Date
Msg-id 200801101614.54729.kevin@kevinkempterllc.com
Whole thread Raw
Responses Re: Best way to index IP data?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Best way to index IP data?  (Steve Atkins <steve@blighty.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: not exists clause
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Best way to index IP data?