Re: Configuring System for Speed

Поиск
Список
Период
Сортировка
От Brian Wipf
Тема Re: Configuring System for Speed
Дата
Msg-id A0D70FD2-8888-4455-9F88-62AF35234026@clickspace.com
обсуждение исходный текст
Ответ на Re: Configuring System for Speed  ("Luke Lonergan" <llonergan@greenplum.com>)
Ответы Re: Configuring System for Speed
Список pgsql-performance
On 8-Sep-06, at 2:44 AM, Luke Lonergan wrote:

> One modification: we implemented two internal 60GB laptop hard
> drives with
> an additional 3Ware 8006-2LP controller on each machine for the OS.
> This
> frees up all 16 SATA II drives for data.

That's a great idea. One question though. If I put all 16 drives in a
RAID 10 for the database, where should I put the logs? On that large
RAID set? If I use a RAID controller with a BB cache for the mirrored
laptop drives, might I be able to use that for the logs and OS?

Brian Wipf


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Abysmal hash join
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: Abysmal hash join