Re: Postgresql backend to perform vacuum automatically

From: Turbo Fredriksson <turbo(at)bayour(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgresql backend to perform vacuum automatically
Date: 2002-03-06 09:06:29
Message-ID: 87eliydq0a.fsf@papadoc.bayour.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "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'... ?
--
Noriega Peking smuggle Iran jihad spy domestic disruption Cocaine CIA
kibo Waco, Texas toluene iodine Qaddafi FSF
[See http://www.aclu.org/echelonwatch/index.html for more about this]

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jean-Paul ARGUDO 2002-03-06 09:24:37 Re: Drop in performance for each INSERT/DELETE combo
Previous Message Zeugswetter Andreas SB SD 2002-03-06 08:35:16 Re: Postgresql backend to perform vacuum automatically