Re: [GENERAL] Strange checkpoint behavior - checkpoints take alongtime - Mailing list pgsql-general

From Andres Freund
Subject Re: [GENERAL] Strange checkpoint behavior - checkpoints take alongtime
Date
Msg-id 20171006030329.emrm24hvf2si6kv3@alap3.anarazel.de
Whole thread Raw
In response to Re: [GENERAL] Strange checkpoint behavior - checkpoints take alongtime  (Vladimir Nicolici <vladnc@gmail.com>)
List pgsql-general
Hi,

On 2017-10-06 05:53:39 +0300, Vladimir Nicolici wrote:
> Hello, it’s postgres 9.6.

Consider setting checkpoint_flush_after to 16MB or something large like that.


> I will probably try the compression on Monday or Tuesday, I can only
> experiment with a single set of changes in a day, and I plan to test
> something else tomorrow.
> 
> Thanks for the suggestions, and sorry for the reply style, but my mail
> client is not best suited for replying inline to individual points.

You should consider getting a new mail client then...

- Andres


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Vladimir Nicolici
Date:
Subject: Re: [GENERAL] Strange checkpoint behavior - checkpoints take alongtime
Next
From: vinny
Date:
Subject: Re: [GENERAL] delete a file everytime pg server starts/crashes