Re: Re: index and data tablespaces on two separate drives or one RAID 0?

Поиск
Список
Период
Сортировка
От Joe Miller
Тема Re: Re: index and data tablespaces on two separate drives or one RAID 0?
Дата
Msg-id CAF0YBYv1NTJvRMCatHFwNYTqpEzGLN_H=hDs6d9u4SxF0Y5MXw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: index and data tablespaces on two separate drives or one RAID 0?  (ach <alanchines@gmail.com>)
Список pgsql-general
On Fri, Jul 6, 2012 at 8:51 PM, ach <alanchines@gmail.com> wrote:
> My fastest postgresql servers have everything on one raid10, using 16 or
> 20 15000 rpm SAS2 drives on a 1gb flash-backed cache controller.

Thank you - that affirms what'd been my own growing supposition, and the
plan

> why?

Really?  ...Well, I mean, I'd just been going with what I'd seen asserted as
the solid baseline position:  WAL should be on its own separate drive,
devoid of any interference and/or interruption other than just writing WAL.
To see that challenged is surprising; are you saying my interpretation on
that point would be incorrect, and that assumption would be wrong?

Thank you again for your feedback!


I wouldn't make any assumptions, and benchmark various configurations using your hardware and your data usage pattern. Sometimes "common knowledge" doesn't apply to your specific problem.
 

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

Предыдущее
От: Gurjeet Singh
Дата:
Сообщение: Re: Suboptimal query plan fixed by replacing OR with UNION
Следующее
От: Perry Smith
Дата:
Сообщение: Re: Help with sql