Re: Postgresql backend to perform vacuum automatically

Turbo Fredriksson wrote:
> >>>>> "Bruce" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>
> >> Are there tables that track information that would be useful
> >> for guiding vacuum? Could I write a program which queries some
> >> statistical tables and and knows which tables need to be
> >> vacuumed?
> >>
> >> If the info is around, I could whip up something pretty easily,
> >> I think.
>
> Bruce> Sure, Jan's new statistics tables in 7.2 had just that
> Bruce> info.
>
> Bruce> test=> \d pg_stat_user_tables
>
> I don't have that table. Only 'pg_statistic'... ?

Upgrade to 7.2.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026