Re: Calculating how much redo log space has been used

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Calculating how much redo log space has been used
Дата
Msg-id 20180814193118.65ohih2n3n4ojc7y@alap3.anarazel.de
обсуждение исходный текст
Ответ на Calculating how much redo log space has been used  (Reza Taheri <rtaheri@vmware.com>)
Ответы RE: Calculating how much redo log space has been used  (Reza Taheri <rtaheri@vmware.com>)
Список pgsql-performance
Дерево обсуждения 
Hi,

On 2018-08-14 18:51:34 +0000, Reza Taheri wrote:
> Also, it looks like the full_page_writes parameter is the only thing
> that can help reduce the log usage size

There's also wal_compression.


> Another requirement is a very short, 6-minute checkpoint time, which
> means we will likely write the full page very often. Yes, my hands are
> tied!

Why is that a requirement / how is specifically phrased? Is it a bounded
recovery time?

Greetings,

Andres Freund

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

Предыдущее
От: Reza Taheri
Дата:
Сообщение: Calculating how much redo log space has been used
Следующее
От: legrand legrand
Дата:
Сообщение: Re: Fwd: increase insert into local table from remote oracle tablepreformance