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. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers