Re: increasing the default WAL segment size

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: increasing the default WAL segment size
Дата
Msg-id 20160825175007.quljdme4xnb434vc@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: increasing the default WAL segment size  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: increasing the default WAL segment size  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 2016-08-25 13:45:29 -0400, Robert Haas wrote:
> I think you may be forgetting that "the base 3 WAL segments" is no
> longer the default configuration.  checkpoint_segments=3 is history;
> we now have max_wal_size=1GB, which is a maximum of 64 WAL segments,
> not 3.

Well, but min_wal_size still is 48MB. So sure, if you consistently have
a high WAL throughput, it'll be bigger. But otherwise pg_xlog will
shrink again.



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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: increasing the default WAL segment size
Следующее
От: Robert Haas
Дата:
Сообщение: Re: increasing the default WAL segment size