Re: Tuning PostgreSQL

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Tuning PostgreSQL
Дата
Msg-id 200307210906.10226.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Tuning PostgreSQL  ("Alexander Priem" <ap@cict.nl>)
Ответы Re: Tuning PostgreSQL  (Vincent van Leeuwen <pgsql.spam@vinz.nl>)
Список pgsql-performance
Alexander,

> Hmmm. Seems to me that this setup would be better than one RAID5 with three
> 36Gb disks, wouldn't you think so? With one RAID5 array, I would still have
> the data and the WAL on one volume...

Definitely.   As I've said, my experience with RAID5 is that with less than 5
disks, it performs around 40% of a single scsi disk for large read-write
operation on Postgres.

If you have only 3 disks, I'd advocate one disk for WAL and one RAID 1 array
for the database.

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: "Alexander Priem"
Дата:
Сообщение: Re: Tuning PostgreSQL
Следующее
От: Vincent van Leeuwen
Дата:
Сообщение: Re: Tuning PostgreSQL