On Mon, Feb 27, 2012 at 3:50 AM, Simon Riggs <simon(at)2ndquadrant(dot)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.
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2012-02-27 13:17:21|
|Subject: Re: check constraint validation takes access exclusive locks|
|Previous:||From: hubert depesz lubaczewski||Date: 2012-02-27 13:02:57|
|Subject: Re: check constraint validation takes access exclusive