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

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


Reply via email to