Darcy Buskermolen <[EMAIL PROTECTED]> writes: > I was thinking of changing the way EFC is handled, having it retrived via code > (much the same way top does it) rather than relying on the user to specify > the value. This value would then be checked/updated every so often.
Even assuming that you can portably find out how much RAM is going to kernel cache (which I do not believe), how do you know how much of it is getting used for Postgres data as opposed to everything else? At the moment I think that manual handling is sufficient anyway. This is a relatively low-impact parameter and it doesn't seem too important to try to get it dead on. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html