Index, Tablespace and performance - Mailing list pgsql-general

From alexandre::aldeia digital
Subject Index, Tablespace and performance
Date
Msg-id 41D87908.9040408@aldeiadigital.com.br
Whole thread Raw
List pgsql-general
Hi,


I have a 4 x SCSI in RAID 10 (PG 7.4.6) with a regular performance.
My database have 55 Gb of data.

In PG 8, moving the indexes to a separeted disk (or array) can
(generally) improve the performance if the system make a heavy use of
indexes ?

Thanks

Alexandre

pgsql-general by date:

Previous
From: Ragnar Hafstað
Date:
Subject: Re: Shared Sequences?
Next
From: Timothy Perrigo
Date:
Subject: Re: OS X shared memory problems 8.0rc3