Re: two disks - best way to use them?

Поиск
Список
Период
Сортировка
От David Lang
Тема Re: two disks - best way to use them?
Дата
Msg-id Pine.LNX.4.62.0512051950560.2807@qnivq.ynat.uz
обсуждение исходный текст
Ответ на Re: two disks - best way to use them?  (Thomas Harold <tgh@tgharold.com>)
Ответы Re: two disks - best way to use them?  (Thomas Harold <tgh@tgharold.com>)
Список pgsql-performance
On Mon, 5 Dec 2005, Thomas Harold wrote:

> Yeah, I don't think I was clear about the config.  It's (4) disks setup as a
> pair of RAID1 sets.  My original config was pgsql on the first RAID set (data
> and WAL).  I'm now experimenting with putting the data/pg_xlog folder on the
> 2nd set of disks.
>
> Under the old setup (everything on the original RAID1 set, in a dedicated
> 32GB LVM volume), I was seeing 80-90% wait percentages in "top".  My
> understanding is that this is an indicator of an overloaded / bottlenecked
> disk system.  This was while doing massive inserts into a test table
> (millions of narrow rows).  I'm waiting to see what happens once I have
> data/pg_xlog on the 2nd disk set.

in that case you logicly have two disks, so see the post from Ron earlier
in this thread.

David Lang

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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: 15,000 tables - next step
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BLCKSZ