From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Greg Smith <greg(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Initial 9.2 pgbench write results |
Date: | 2012-02-27 19:12:07 |
Message-ID: | CA+U5nM+G-dhnPH_e7nKDkOA6rnQYABg_rX3EMFU=jtu9gmgnOQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Feb 27, 2012 at 1:08 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> 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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2012-02-27 19:19:13 | Re: Command Triggers, patch v11 |
Previous Message | Erik Rijkers | 2012-02-27 19:05:29 | Re: pgstat documentation tables (pdf OK on centos) |