Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Дата
Msg-id 28304.1148044220@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2  ("Olivier Andreotti" <olivier.andreotti@gmail.com>)
Список pgsql-performance
"Olivier Andreotti" <olivier.andreotti@gmail.com> writes:
> Just a last question about the pg_xlog : i understand that the
> directory must be moved but i have just 3 disks for the database :
> disk 1 and 2 for the data, disk 3 for the indexes, where can i put the
> pg_xlog ?

If you have three disks then put the xlog on one of them and everything
else on the other two.  Separating out the indexes is way less important
than getting xlog onto its very own spindle (at least for
write-intensive cases).

            regards, tom lane

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

Предыдущее
От: "Olivier Andreotti"
Дата:
Сообщение: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle