Re: index - Mailing list pgsql-performance

From Euler Taveira de Oliveira
Subject Re: index
Date
Msg-id 496DEB27.6090904@timbira.com
Whole thread Raw
In response to index  ("Maksim Sosnovskiy" <msosno01@gmail.com>)
List pgsql-performance
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/

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Slow insert performace, 8.3 Wal related?
Next
From: Jörg Kiegeland
Date:
Subject: row-specific conditions possible?