Tom Lane wrote: > Bruno Wolff III <[EMAIL PROTECTED]> writes: > >>I don't think there is much point in making it configurable. If they knew >>to do that they would most likely know to vacuum as well. > > > Agreed. > > >>However, 100K out of 1G seems too small. Just to get wrap around there >>must be a pretty high transaction rate, so 100K may not give much warning. >>1M or 10M seem to be better. > > > Good point. Even 10M is less than 1% of the ID space. Dunno about you, > but the last couple cars I've owned start flashing warnings when the gas > tank is about 20% full, not 1% full...
BTW, why not do an automatic vacuum instead of shutdown ? At least the DB do not stop working untill someone study what the problem is and how solve it. Regards Gaetano Mendola ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq