Storing data and indexes in different disks

Поиск
Список
Период
Сортировка
От Alvaro Nunes Melo
Тема Storing data and indexes in different disks
Дата
Msg-id 42CC1BC7.7060902@atua.com.br
обсуждение исходный текст
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Paul Johnson"
Дата:
Сообщение: Data Warehousing Tuning
Следующее
От: "Dmitri Bichko"
Дата:
Сообщение: Re: Storing data and indexes in different disks