Re: Best practice

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Best practice
Дата
Msg-id 23276.987722491@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Best practice  (geustace@godzone.net.nz)
Список pgsql-general
geustace@godzone.net.nz writes:
> We use Ingres where I work and when setting up a server we always
> try to ensure that the log and data files are on different spindles.

This would be good practice in PG simply for performance reasons.
Ideally the WAL log should be on a disk that has nothing else to do,
so that you never have to seek somewhere else than the current WAL
segment.

I'm not sure that we can yet guarantee very much about recovery from
disk hardware failures.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Delete w/ regexp
Следующее
От: Phuong Ma
Дата:
Сообщение: password authentication