Re: autovacuum logging, part deux.
От | Rod Taylor |
---|---|
Тема | Re: autovacuum logging, part deux. |
Дата | |
Msg-id | 1146760668.856.3.camel@home обсуждение исходный текст |
Ответ на | Re: autovacuum logging, part deux. ("Larry Rosenman" <lrosenman@pervasive.com>) |
Ответы |
Re: autovacuum logging, part deux.
|
Список | pgsql-hackers |
On Thu, 2006-05-04 at 11:25 -0500, Larry Rosenman wrote: > Rod Taylor wrote: > > I don't know about anyone else, but the only time I look at that mess > > is to find poor tuple/table or tuple/index ratios and other > > indications that vacuum isn't working as well as it should be. > > > > How about this instead: > > > > Log when the actual autovacuum_vacuum_scale_factor (dead space cleaned > > up) was more than 2 times the autovacuum_vacuum_scale_factor listed in > > postgresql.conf. This means autovacuum isn't keeping up to what you > > want it to. > > > > Another interesting case would be a large amount of empty space in the > > index or table (say 3x autovacuum_vacuum_scale_factor). This may > > indicate unnecessary bloat and something to fix. > > > > Aside from that, the raw numbers don't really interest me. > > > > Does anyone think we should have a stats view for the last vacuum stats > for each table? This would actually suit me better as it would be trivial to plug into a monitoring system with home-brew per table thresholds at that point. --
В списке pgsql-hackers по дате отправления: