From: Alvaro Nunes Melo <al_nunes@atua.com.br>
To: PostgreSQL - Performance <pgsql-performance@postgresql.org>
Subject: Storing data and indexes in different disks
Date: Wed, 06 Jul 2005 14:58:31 -0300
Message-ID: <42CC1BC7.7060902@atua.com.br> (raw)
Hi,
I'm about to recommend a server model to a client, and I've read a in
many places (including in this list) that storing indexes in one disk
and the rest of the database in other disk might increase the overall
performance of the system in about 10%.
Making this only by a symbolic link is enough, or there are any futher
steps? We were thinking (for costs reasons) in use only 2 SCSI disks,
without any level of RAID. Is this enough to achieve performance
improvement mentioned above?
Best regards,
Alvaro
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: al_nunes@atua.com.br
Subject: Re: Storing data and indexes in different disks
In-Reply-To: <42CC1BC7.7060902@atua.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox