On Mon, Feb 27, 2012 at 1:08 PM, Robert Haas <robertmh...@gmail.com> wrote: > On Mon, Feb 27, 2012 at 3:50 AM, Simon Riggs <si...@2ndquadrant.com> wrote: >> That isn't the case. We have evidence that the current knobs are >> hugely ineffective in some cases. >> >> Turning the bgwriter off is hardly "adjusting a setting", its >> admitting that there is no useful setting. >> >> I've suggested changes that aren't possible by tuning the current knobs. > > OK, fair point. But I don't think any of us - Greg included - have an > enormously clear idea why turning the background writer off is > improving performance in some cases. I think we need to understand > that better before we start changing things.
I wasn't suggesting we make a change without testing. The theory that the bgwriter is doing too much work needs to be tested, so we need a proposal for how to reduce that work in a coherent way so we can test, which is what I've given. Other proposals are also possible. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers