RE: Calculating how much redo log space has been used

2018-08-15 Thread Reza Taheri
> -Original Message- > From: Andres Freund [mailto:and...@anarazel.de] > Sent: Tuesday, August 14, 2018 12:31 PM > To: Reza Taheri > Cc: pgsql-performa...@postgresql.org > Subject: Re: Calculating how much redo log space has been used > > Hi, > > On 2

Re: Calculating how much redo log space has been used

2018-08-14 Thread Andres Freund
Hi, On 2018-08-14 18:51:34 +, 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