index - Mailing list pgsql-performance

From Maksim Sosnovskiy
Subject index
Date
Msg-id 3ca44b7d0901132153w142d7548ge90192375d8e56e8@mail.gmail.com
Whole thread Raw
Responses Re: index  ("David Wilson" <david.t.wilson@gmail.com>)
Re: index  (Euler Taveira de Oliveira <euler@timbira.com>)
List pgsql-performance
We are currently storing a large amount of networking data. The
database size is over 50 Gigabytes. It also grows by 10 Gigabytes
every month.

We are looking if there is a way to speedup lookups by IP Address.

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?

--
Regards,

Maksim

pgsql-performance by date:

Previous
From: "Mark Wong"
Date:
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Next
From: "David Wilson"
Date:
Subject: Re: index