We are currently storing a large amount of networking data. The
database size is over 50 Gigabytes. It also grows by 10 Gigabytes
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?
- 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 Wilson||Date: 2009-01-14 06:16:13|
|Subject: Re: index|
|Previous:||From: Mark Wong||Date: 2009-01-14 03:49:25|
|Subject: Re: dbt-2 tuning results with postgresql-8.3.5|