Maksim Sosnovskiy escreveu:
> The primary key is a set of values. And the key does include IP
> Address as well. Will it be more efficient to also add index on IP
> Address to speedup lookups by IP?
>
It depends on what set of queries that you run. If the most frequent queries
use ip_field, then you need an index on it. Maybe you could try ip4r [1].
[1] http://pgfoundry.org/projects/ip4r/
--
Euler Taveira de Oliveira
http://www.timbira.com/