Re: pgsql: Make WAL segment size configurable at initdb time.

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pgsql: Make WAL segment size configurable at initdb time.
Дата
Msg-id 20180921045316.GI1338@paquier.xyz
обсуждение исходный текст
Ответ на Re: pgsql: Make WAL segment size configurable at initdb time.  (Andres Freund <andres@anarazel.de>)
Ответы Re: pgsql: Make WAL segment size configurable at initdb time.  (David Steele <david@pgmasters.net>)
Список pgsql-committers
On Thu, Sep 20, 2018 at 06:23:54PM -0700, Andres Freund wrote:
> 16*M*B, right?  If so, that's normal - pg_settings just reports the
> values in the underlying unit - which is XLOG_BLCKSZ, compile-time
> defaulting to 8KB. 8192 * 2048 = 16MB.  That's the same in various other
> settings.

Would it bring less confusion if we append something like "When querying
pg_settings"?  I can see David's point the current phrasing is
confusing: we don't know if this comes from pg_settings or from SHOW.
It obviously refers to the former, but one can understand that it refers
to the latter.

A second parameter in config.sgml where this formulation is used is
segment_size.
--
Michael

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: pgsql: Error out for clang on x86-32 without SSE2 support,no -fexcess-
Следующее
От: Michael Paquier
Дата:
Сообщение: pgsql: Document lock taken on referenced table when adding a foreignke