Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Bruce Momjian) would write: > I guess my question is that now that we have the new cache > replacement policy, is the vacuum delay worth while. I looked at > http://developer.postgresql.org/~wieck/vacuum_cost/ and does seem > useful.
They satisfy quite separate use cases, so both are surely useful. - The new cache replacement policy allows us to make sure that cache isn't getting blown on worthless things. - Vacuum delay allows us to make sure that we aren't spending all our I/O on vacuuming. There is overlap between their uses, as both should help diminish the use of I/O to fill buffers with data that was discarded, but they surely have separate uses. -- "cbbrowne","@","acm.org" http://www.ntlug.org/~cbbrowne/lisp.html You know that little indestructible black box that is used on planes---why can't they make the whole plane out of the same substance? ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
