Re: WAL directory size calculation

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: WAL directory size calculation
Дата
Msg-id CAKFQuwaMGb-qMnf0T0F35NQg_FidzVugnBYhSz3AybMwkwppOg@mail.gmail.com
обсуждение исходный текст
Ответ на WAL directory size calculation  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Ответы Re: WAL directory size calculation  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Re: WAL directory size calculation  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Jul 28, 2016 at 9:25 AM, Moreno Andreo <moreno.andreo@evolu-s.it> wrote:
I've read somewhere that the formula should be 16 MB * 3 * checkpoint_segment in size.
​[...]​
 
Using the above formula I have:
    16 MB * 3 * 1 GB
that leads to to ... uh .. 48000 TB?

​You seem to be mis-remembering the formula.​

​checkpoiint_segments is a quantity (i.e., unit-less), not a size.  Saying its "1GB" makes no sense.

​I'm also doubting you multiply it by 3 - add three to it maybe...

​Each segment takes 16MB.  The total space required is that times whatever maximum count of segments you expect to have.​

I'd suggest waiting for better responses on these lists or searching out prior conversations on this topic - of which I am sure there are many.

David J.

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

Предыдущее
От: Moreno Andreo
Дата:
Сообщение: WAL directory size calculation
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Uber migrated from Postgres to MySQL