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/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
