Re: Vacuums on large busy databases

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Vacuums on large busy databases
Дата
Msg-id cone.1158625276.426992.91426.5001@35st-server.simplicato.com
обсуждение исходный текст
Ответ на Vacuums on large busy databases  (Francisco Reyes <lists@stringsutils.com>)
Список pgsql-performance
Jim C. Nasby writes:

> BTW, on some good raid controllers (with battery backup and
> write-caching), putting pg_xlog on a seperate partition doesn't really
> help, so you might want to try combining everything.

Planning to put a busy database on second raid or perhaps some index files.
So far the second raid is highly under utilized.

> Even if you stay with 2 partitions, I'd cut pg_xlog back to just a
> simple mirror.

I am considering to put the pg_xlog back to the main raid. Primarily because
we have two hot spares.. on top of RAID 10.. so it is safer.

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

Предыдущее
От: Marc McIntyre
Дата:
Сообщение: LIKE query problem
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Large tables (was: RAID 0 not as fast as expected)