Re: Postgresql backend to perform vacuum automatically

>>>>> "Bruce" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:

Bruce> 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'... ?

Bruce> Upgrade to 7.2.

Doh! I have :)
--
FSF Peking AK-47 Nazi arrangements quiche explosion jihad ammunition
North Korea toluene spy Treasury FBI congress
[See http://www.aclu.org/echelonwatch/index.html for more about this]