Re: increasing the default WAL segment size

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: increasing the default WAL segment size
Дата
Msg-id 1427.1472092429@sss.pgh.pa.us
обсуждение исходный текст
Ответ на increasing the default WAL segment size  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: increasing the default WAL segment size  (Andres Freund <andres@anarazel.de>)
Re: increasing the default WAL segment size  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I'd like to propose that we increase the default WAL segment size,
> which is currently 16MB.

That seems like a reasonable thing to consider ...

> Possibly it would make sense for this to be configurable at initdb
> time instead of requiring a recompile;

... but I think this is just folly.  You'd have to do major amounts
of work to keep, eg, slave servers on the same page as the master
about what the segment size is.  Better to keep treating it like
BLCKSZ, as a fixed parameter of a build.  (There's a reason why we
keep this number in pg_control.)
        regards, tom lane



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

Предыдущее
От: Gerdan Santos
Дата:
Сообщение: Re: \timing interval
Следующее
От: Gerdan Santos
Дата:
Сообщение: Re: \timing interval