Rick Gigger <[EMAIL PROTECTED]> writes: >> By default, autovacuum isn't even turned on --- you have to enable it >> and also stats_row_level if you want to use autovac. I don't have >> enough experience with it to say whether the other settings are >> adequate.
> Yes, I realized this not long after I started things up, so I will > have to wait till a time when I can restart postgres to try it out. As long as you left stats_start_collector on, that's not so. autovacuum and stats_row_level can both be changed without a postmaster restart; just fix the config file and SIGHUP. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq