index

From: "Maksim Sosnovskiy" <msosno01(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: index
Date: 2009-01-14 05:53:52
Message-ID: 3ca44b7d0901132153w142d7548ge90192375d8e56e8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: index at 2009-01-14 06:16:13 from David Wilson
  • Re: index at 2009-01-14 13:39:51 from Euler Taveira de Oliveira

Browse pgsql-performance by date

  From Date Subject
Next Message David Wilson 2009-01-14 06:16:13 Re: index
Previous Message Mark Wong 2009-01-14 03:49:25 Re: dbt-2 tuning results with postgresql-8.3.5