Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Peter Eisentraut) would write: > Jim C. Nasby wrote: >> I thought we had agreed it would be a good idea to turn autovac_delay >> on? > > We had not, because there was no experience available about where to put > the default numbers.
I would also not because for Very Large Tables, the delay may make vacuums run really inordinately long. And that becomes an "evil big long-running transaction" to worsen things. -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "gmail.com") http://cbbrowne.com/info/internet.html Signs of a Klingon Programmer - 2. "Specifications are for the weak and timid!" ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster