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
