Re: Let's drop some GUCs (bgwriter) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Let's drop some GUCs (bgwriter)
Date
Msg-id 26794.1124757753@sss.pgh.pa.us
Whole thread Raw
In response to Let's drop some GUCs (bgwriter)  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> I find the addition a little baffling, since previous tests ... both mine, 
> and discussion of tests last December ... showed that manipulating the 
> bgwriter variables had no useful effects, and one might as well leave them 
> alone.

Perhaps that just proves that you're using a test that's insensitive to
bgwriter effects; or that the defaults are so far off optimal that the
range of values you experimented with are all equally bad.  Certainly
you cannot point to tests from last December as meaning anything
relevant to CVS tip, because the bgwriter algorithms have changed
completely since then.

The fact is that we don't know optimal settings for these values, and
removing the variables that make it convenient to experiment with them
will accomplish nothing except to guarantee that no one ever does
experiment enough to find out what the optimal values are.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Let's drop some GUCs (bgwriter)
Next
From: Tom Lane
Date:
Subject: Re: Inconsistencies with create role