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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

Reply via email to