Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql latency & bgwriter not doing its job - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: postgresql latency & bgwriter not doing its job
Date
Msg-id CAMkU=1w-Jwn3=C1JKpmU9RCvdu-jG6pxnLj5AOovkPozXqH04g@mail.gmail.com
Whole thread Raw
In response to postgresql latency & bgwriter not doing its job  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: postgresql latency & bgwriter not doing its job
List pgsql-hackers
Tree view
On Monday, August 25, 2014, Fabien COELHO <coelho@cri.ensmp.fr> wrote:

I have not found any mean to force bgwriter to send writes when it can. (Well, I have: create a process which sends "CHECKPOINT" every 0.2 seconds... it works more or less, but this is not my point:-)

There is scan_whole_pool_milliseconds, which currently forces bgwriter to circle the buffer pool at least once every 2 minutes.  It is currently fixed, but it should be trivial to turn it into an experimental guc that you could use to test your hypothesis.
 
Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Escaping from blocked send() reprised.
Next
From: Fabien COELHO
Date:
Subject: Re: postgresql latency & bgwriter not doing its job