Re: [HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Chris Browne
[EMAIL PROTECTED] (Larry Rosenman) writes: Gentlepeople, Now that the patch is out for keeping the last autovacuum/vacuum/analyze/autoanalyze timestamp in the stats system is pending, what's the consensus view on what, if any, logging changes are wanted for autovacuum? I have the

Re: [HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Rod Taylor
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

Re: [HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Larry Rosenman
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

Re: [HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Rod Taylor
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

Re: [HACKERS] autovacuum logging, part deux.

2006-05-04 Thread Jim C. Nasby
On Thu, May 04, 2006 at 12:37:48PM -0400, Rod Taylor wrote: 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