Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql backend to perform vacuum automatically - Mailing list pgsql-hackers

From Turbo Fredriksson
Subject Re: Postgresql backend to perform vacuum automatically
Date
Msg-id 87eliydq0a.fsf@papadoc.bayour.com
Whole thread Raw
In response to Re: Postgresql backend to perform vacuum automatically  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Postgresql backend to perform vacuum automatically
List pgsql-hackers
Tree view 
>>>>> "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
whichqueries some   >> statistical tables and and knows which tables need to be   >> vacuumed?   >>    >> If the info
isaround, 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]

pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Postgresql backend to perform vacuum automatically
Next
From: Jean-Paul ARGUDO
Date:
Subject: Re: Drop in performance for each INSERT/DELETE combo