Re: partition question for new server setup

Поиск
Список
Период
Сортировка
От Whit Armstrong
Тема Re: partition question for new server setup
Дата
Msg-id 8ec76080904290728ke4150cfsf1d46ff9c6c1dbd4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: partition question for new server setup  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
Thanks, Scott.

> I went with ext3 for the OS -- it makes Ops feel a lot better. ext2 for a
> separate xlogs partition, and xfs for the data.
> ext2's drawbacks are not relevant for a small partition with just xlog data,
> but are a problem for the OS.

Can you suggest an appropriate size for the xlogs partition?  These
files are controlled by checkpoint_segments, is that correct?

We have checkpoint_segments set to 500 in the current setup, which is
about 8GB.  So 10 to 15 GB xlogs partition?  Is that reasonable?

-Whit

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

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: partition question for new server setup
Следующее
От: Whit Armstrong
Дата:
Сообщение: Re: partition question for new server setup