Turbo Fredriksson wrote:
> >>>>> "Bruce" == Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
