Home > mailing lists

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

From	Kevin Kempter
Subject	Best way to index IP data?
Date	January 10, 2008 22:15:22
Msg-id	200801101614.54729.kevin@kevinkempterllc.com Whole thread Raw
Responses	Re: Best way to index IP data? Re: Best way to index IP data?
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:

From: Josh Berkus
Date: 10 January 2008, 20:47:55
Subject: Re: not exists clause

From: "Joshua D. Drake"
Date: 10 January 2008, 22:18:35
Subject: Re: Best way to index IP data?

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

Previous

Next