Re: Status of 8.3 patches

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Heikki Linnakangas wrote:
> Joshua D. Drake wrote:
>> Heikki Linnakangas wrote:
>>> Bruce Momjian wrote:
>>>>   o  Automatic adjustment of bgwriter_lru_maxpages 
>>>>
>>>>      We show this as waiting for performance results.  I am thinking we
>>>>      should hold this for 8.4.
>>> Agreed. I spent close to a week trying different benchmarks and
>>> configurations and simple test cases on a test server and my laptop, and
>>> couldn't demonstrate bgwriter making a positive impact in any
>>> configuration I tried. The theory behind the patch is sound, but it
>>> looks like a lot more testing and analysis is needed.
>> Wouldn't real world testing be needed to actually gain insight to this
>> patch?
> 
> I would expect a fairly static benchmark workload to benefit from having
> a bgwriter, more so than more unpredictable real world applications.

Hmmm, I find that real world applications are quite predictable over
time. Certainly you have spikes (good pr, whatever) but in general with
a little bit of monitoring it is quite possible to evaluate a generally
expected result.

I guess my point is, if the patch looks good and does not appear to hurt
anything, why not apply it? At least that way we can start to review the
progress of the feature itself as it starts to see use.

Sincerely,

Joshua D. Drake




- --
     === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/        UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGyftwATb/zqfZUUQRAkwjAJ9xGlzYci6dT3jJy5PrPMYxZOmt0ACffeUm
Br+UQp+k4XVjpyQDSIba4hk=
=jDki
-----END PGP SIGNATURE-----