Data and logs on different physical drives - advantage?

Поиск
Список
Период
Сортировка
От Weber, Johann (ISS Kassel)
Тема Data and logs on different physical drives - advantage?
Дата
Msg-id B8ADDBDA8696F546BDAC69B469D7F0511DABE9@kasmaiexcp01.iss.net
обсуждение исходный текст
Ответы Re: Data and logs on different physical drives - advantage?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
I learned for other database systems, that it is an advantage to have database on one physical drive and transaction logs on a different physical drive, as this should minimize seeks on the hard-disks.
 
Is this true for PostgreSQL (V 8.0 on ReadHat)? My tests do not show any speed gained when placing pg_clog and pg_xlog on a different drive.
 

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

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: Update - pg_dumpall money problem
Следующее
От: Hannes Dorbath
Дата:
Сообщение: Re: Update - pg_dumpall money problem