Re: Scaling further up

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Scaling further up
Дата
Msg-id 200403021326.19998.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Scaling further up  ("Anjan Dave" <adave@vantage.com>)
Список pgsql-performance
Anjan,

> Question - Are 73GB drives supposed to give better performance because
> of higher number of platters?

Not for your situation, no.   Your issue is random seek times for multiple
simultaneous seek requests and batched checkpoint updates.   Things that help
with this are:
More spindles
Better controllers, both RAID and individual disks
Faster drives

Particularly, I'd check out stuff like reports from Tom's Hardware for
evaluating the real speed of drives and seek times.   Often a really good
10000 RPM SCSI will beat a 15000RPM SCSI if the latter has poor onboard
programming.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: Chris Ruprecht
Дата:
Сообщение: Re: Scaling further up
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Database Server Tuning