Re: index

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Maksim Sosnovskiy <msosno01(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: index
Date: 2009-01-14 13:39:51
Message-ID: 496DEB27.6090904@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

  • index at 2009-01-14 05:53:52 from Maksim Sosnovskiy

Browse pgsql-performance by date

  From Date Subject
Next Message Jörg Kiegeland 2009-01-15 10:42:29 row-specific conditions possible?
Previous Message Heikki Linnakangas 2009-01-14 10:10:17 Re: Slow insert performace, 8.3 Wal related?