Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group