Re: Automatic adjustment of bgwriter_lru_maxpages

Greg Smith wrote:
> I realized recently the task I should take on here is to run some more
> experiments with the latest code and pass along suggested techniques for
> producing/identifying the kind of problem conditions I've run into in
> the past; then we can see if other people can reproduce them.  I got a
> new 8-core server I need to thrash anyway and will try and do just that
> starting tomorrow.

Yes, please do that. I can't imagine a situation where a tunable maximum
would help, but you've clearly spent a lot more time experimenting with
it than me.

I have noticed that on a heavily (over)loaded system with fully
saturated I/O, bgwriter doesn't make any difference because all the
backends need to wait for writes anyway. But it doesn't hurt either.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com