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

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

pgsql-performance by date

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

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