Re: Calculating how much redo log space has been used - Mailing list pgsql-performance

From Andres Freund
Subject Re: Calculating how much redo log space has been used
Date
Msg-id 20180814193118.65ohih2n3n4ojc7y@alap3.anarazel.de
Whole thread Raw
In response to Calculating how much redo log space has been used  (Reza Taheri <rtaheri@vmware.com>)
Responses RE: Calculating how much redo log space has been used  (Reza Taheri <rtaheri@vmware.com>)
List 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 by date:

Previous
From: Reza Taheri
Date:
Subject: Calculating how much redo log space has been used
Next
From: legrand legrand
Date:
Subject: Re: Fwd: increase insert into local table from remote oracle tablepreformance