Re: Vacuum does not show in pg_stat_all_tables

Condor <condor(at)stz-bg(dot)com> writes:
> today when I do select relname, last_autovacuum, last_vacuum from
> pg_stat_all_tables I see last_vacuum and autovacuum fields is empty.
> This its seems strange for me, because every night crontab start at
> 01:10 am a vacuum script that do:
> reindex, vacuum full and vacuum analyze. I run vacuumdb not vacuum from
> command line. I use posgresql 9.1.3.

I think last_vacuum tracks regular vacuums, not vacuum full.

This maintenance procedure seems like something that would have been
appropriate back with postgres 7.something, anyway. Do you have any
evidence that you need it at all? autovacuum works reasonably well
for most people, and in any case it seems unlikely that you need a
daily vacuum full or reindex.

regards, tom lane