Re: checkpointer continuous flushing - Mailing list pgsql-hackers

From Amit Langote
Subject Re: checkpointer continuous flushing
Date
Msg-id 556D7AAA.7020800@lab.ntt.co.jp
Whole thread Raw
In response to checkpointer continuous flushing  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: checkpointer continuous flushing
List pgsql-hackers
Hi Fabien,

On 2015-06-01 PM 08:40, Fabien COELHO wrote:
> 
> Turning "checkpoint_flush_to_disk = on" reduces significantly the number
> of late transactions. These late transactions are not uniformly distributed,
> but are rather clustered around times when pg is stalled, i.e. more or less
> unresponsive.
> 
> bgwriter_flush_to_disk does not seem to have a significant impact on these
> tests, maybe because pg shared_buffers size is much larger than the database,
> so the bgwriter is seldom active.
> 

Not that the GUC naming is the most pressing issue here, but do you think
"*_flush_on_write" describes what the patch does?

Thanks,
Amit




pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [GENERAL] psql weird behaviour with charset encodings
Next
From: Mark Kirkwood
Date:
Subject: Re: pg_xlog -> pg_xjournal?