matthew@zeut.net ("Matthew T. O'Connor") writes:
> I think the default settings should be designed to minimize the
> impact autovacuum has on the system while preventing the system from
> ever getting wildly bloated (also protect xid wraparound, but that
> doesn't have anything to do with the thresholds).That would suggest setting the "base threshold" autovacuum_vacuum_threshold relatively low, and the "scale factor" autovacuum_vacuum_scale_factor fairly high. -- let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;; http://cbbrowne.com/info/nonrdbms.html I think it may be possible to simplify and condense the content of this thread somewhat: "GX is an ex-API. It is no longer supported" - The Rest of Us "No it isn't. It's just pining for the fjords!" - Lawson -- Michael Paquette ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
