Re: How do you change the size of the WAL files?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How do you change the size of the WAL files?
Дата
Msg-id 6603.1326153496@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How do you change the size of the WAL files?  (rama <rsomaraju@masergy.com>)
Ответы Re: How do you change the size of the WAL files?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
rama <rsomaraju@masergy.com> writes:
> Due to the small file size I see thousands of files being generated and it
> takes for ever to list thousands of files from archive directory which
> stores 2 days worth of files. Sizing of WAL logs should be left to the
> choice of people using the software. Limiting to a very small random 16MB
> size isn't a good design.

There are tradeoffs in the other direction too, but if you feel you must
have a different value, see configure's --with-wal-segsize option.  Note
that you cannot change this without re-initdb.

            regards, tom lane

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

Предыдущее
От: Ondrej Ivanič
Дата:
Сообщение: Re: Time to move table to new tablespace
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: queries timeout during backup postgres database