Re: index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Jan 14, 2009 at 12:53 AM, Maksim Sosnovskiy <msosno01@xxxxxxxxx> wrote:
Will it be more efficient to also add index on IP
> Address to speedup lookups by IP?

Most likely, especially if the IP address is not the first column in
your primary key index.

Have you done an explain analyze of your ip lookup query? If not, do
so; that can help. Then try creating the index and explain analyze the
query again to see what happens.

Knowing your existing schema/indices and such would let us do more
than guess- and not knowing the plan your current query is using makes
it difficult to know if there's a better one using a to-be-created
index.
-- 
- David T. Wilson
david.t.wilson@xxxxxxxxx

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux