On Jun 26, 2007, at 11:57 PM, Greg Smith wrote:
On Wed, 27 Jun 2007, ITAGAKI Takahiro wrote:
It might be good to use statistics information about buffer usage
to modify X runtime.
I have a complete set of working code that tracks buffer usage
statistics as the background writer scans, so that it has an idea
what % of the buffer cache is dirty, how many pages have each of
the various usage counts, that sort of thing. The problem was that
the existing BGW mechanisms were so clumsy and inefficient that
giving them more information didn't make them usefully smarter.
I'll revive that code again if it looks like it may help here.
Even if it's not used by bgwriter for self-tuning, having that
information available would be very useful for anyone trying to hand-
tune the system.
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
