Going back on-list...

On Tue, Aug 22, 2006 at 08:47:04AM -0400, Alvaro Herrera wrote:
> Jim Nasby wrote:
> > On Aug 17, 2006, at 3:19 PM, Alvaro Herrera wrote:
> > >Nevermind -- it's just that if you vacuum a table which you haven't
> > >touched (insert, update, delete) since the last stats reset, then the
> > >vacuum info isn't recorded because we refuse to create the pgstat  
> > >entry
> > >for the table.
> > 
> > Have you changed this?
> No ...
> > ISTM that it should go ahead and create the  pgstat entry...
> What for?

While on the surface it makes sense not to have a stat entry for a table
"with no activity" (since no activity means no need to vacuum), there's
2 problems:

This doesn't exactly meet the test of 'least surprise'. If the table's
vacuumed for any reason (even manually), we should record the info.

If there's a bunch of activity on a table but stats are reset before a
vacuum is run on it and then a vacuum is run, the user will still be
left thinking that the table needs to be vacuumed.
Jim C. Nasby, Database Architect                   [EMAIL PROTECTED]
512.569.9461 (cell)                         http://jim.nasby.net

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to