Re: What exactly is postgres doing during INSERT/UPDATE ?

Поиск
Список
Период
Сортировка
От Joseph S
Тема Re: What exactly is postgres doing during INSERT/UPDATE ?
Дата
Msg-id h78piu$1sce$1@news.hub.org
обсуждение исходный текст
Ответ на Re: What exactly is postgres doing during INSERT/UPDATE ?  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: What exactly is postgres doing during INSERT/UPDATE ?  (Luke Koops <luke.koops@entrust.com>)
Список pgsql-performance
Дерево обсуждения 
Scott Marlowe wrote:

> After that you have to start looking at hardware.  Soimething as
> simple as a different drive for indexes and another for WAL, and
> another for the base tables can make a big difference.
>
If I have 14 drives in a RAID 10 to split between data tables and
indexes what would be the best way to allocate the drives for performance?

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

Предыдущее
От: Joseph S
Дата:
Сообщение: Re: What exactly is postgres doing during INSERT/UPDATE ?
Следующее
От: Jean-Michel Pouré
Дата:
Сообщение: Memory monitoring tool