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 .
Euler Taveira de Oliveira
In response to
- index at 2009-01-14 05:53:52 from Maksim Sosnovskiy
pgsql-performance by date
|Next:||From: Jörg Kiegeland||Date: 2009-01-15 10:42:29|
|Subject: row-specific conditions possible?|
|Previous:||From: Heikki Linnakangas||Date: 2009-01-14 10:10:17|
|Subject: Re: Slow insert performace, 8.3 Wal related?|