From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Neil Conway <neilc(at)samurai(dot)com>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
Subject: | Re: Status of 8.3 patches |
Date: | 2007-08-20 20:50:48 |
Message-ID: | 46C9FEA8.7090301@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Heikki Linnakangas wrote:
> Joshua D. Drake wrote:
>> Heikki Linnakangas wrote:
>>> Joshua D. Drake wrote:
>>>> Heikki Linnakangas wrote:
>>>>> Bruce Momjian wrote:
>>>>>> o Automatic adjustment of bgwriter_lru_maxpages
\
>>> 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.
>
> If it doesn't appear to have any positive effect, why would we apply it?
We don't know if it has a positive effect. My understanding is that your
testing shows that it does not appear to have a negative effect. Those
are different things don't you think?
>
> If we apply the patch, how would you monitor it's effectiveness in a
> live database? There's nothing to compare against.
>
Well that's valid. A production database you really don't want to be
fiddling. *shrug*
I hate to see potential lost, but if it isn't a good fit....
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
iD8DBQFGyf6oATb/zqfZUUQRAjLrAJ9lknJRIoAe7EsFWlD3PQeXPZXjMgCdE2ze
bGNC5JpSE2DMQuKWrOf9fqI=
=rL19
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2007-08-20 21:02:13 | Re: Status of 8.3 patches |
Previous Message | Joshua D. Drake | 2007-08-20 20:48:27 | Re: Status of 8.3 patches |