Re: increasing the default WAL segment size

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: increasing the default WAL segment size
Дата
Msg-id 3da80f0f-dc39-286b-d772-080becea095a@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: increasing the default WAL segment size  (David Steele <david@pgmasters.net>)
Ответы Re: increasing the default WAL segment size
Список pgsql-hackers
On 3/24/17 19:13, David Steele wrote:
> Behavior for the current default of 16MB is unchanged, and all other 
> sizes go through a logical progression.

Just at a glance, without analyzing the math behind it, this scheme
seems super confusing.

> 
> 1GB:
> 000000010000000000000040
> 000000010000000000000080
> 0000000100000000000000C0
> 000000010000000100000000
> 
> 256GB:
> 
> 000000010000000000000010
> 000000010000000000000020
> 000000010000000000000030
> ...
> 0000000100000000000000E0
> 0000000100000000000000F0
> 000000010000000100000000
> 
> 64GB:
> 
> 000000010000000100000004
> 000000010000000100000008
> 00000001000000010000000C
> ...
> 0000000100000001000000F8
> 0000000100000001000000FC
> 000000010000000100000000


-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Corey Huinker
Дата:
Сообщение: Re: \if, \elseif, \else, \endif (was Re: PSQL commands:\quit_if, \quit_unless)
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: increasing the default WAL segment size