Re: Configuration Recommendations

Поиск
Список
Период
Сортировка
От John Lister
Тема Re: Configuration Recommendations
Дата
Msg-id 4FA22B92.6050103@kickstone.co.uk
обсуждение исходный текст
Ответ на Re: Configuration Recommendations  (Jan Nielsen <jan.sture.nielsen@gmail.com>)
Ответы Re: Configuration Recommendations  (Jan Nielsen <jan.sture.nielsen@gmail.com>)
Список pgsql-performance
On 03/05/2012 03:10, Jan Nielsen wrote:

300GB RAID10 2x15k drive for OS on local storage
*/dev/sda1 RA*                                            4096
*/dev/sda1 FS*                                            ext4 
*/dev/sda1 MO*

600GB RAID 10 8x15k drive for $PGDATA on SAN
*IO Scheduler sda*            noop anticipatory deadline [cfq]
*/dev/sdb1 RA*                                            4096
*/dev/sdb1 FS*                                             xfs
*/dev/sdb1 MO*       
allocsize=256m,attr2,logbufs=8,logbsize=256k,noatime             

300GB RAID 10 2x15k drive for $PGDATA/pg_xlog on SAN
*IO Scheduler sdb*            noop anticipatory deadline [cfq]
*/dev/sde1 RA*                                            4096
*/dev/sde1 FS*                                             xfs
*/dev/sde1 MO*        allocsize=256m,attr2,logbufs=8,logbsize=256k,noatime
*

I was wondering if it would be better to put the xlog on the same disk as the OS? Apart from the occasional log writes I'd have thought most OS data is loaded into cache at the beginning, so you effectively have an unused disk. This gives you another spindle (mirrored) for your data.

Or have I missed something fundamental?

-- 
www.pricegoblin.co.uk

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

Предыдущее
От: Josh Turmel
Дата:
Сообщение: Query got slow from 9.0 to 9.1 upgrade
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Several optimization options (config/hardware)