Re: Postgresql backend to perform vacuum automatically

Поиск
Список
Период
Сортировка
От Turbo Fredriksson
Тема Re: Postgresql backend to perform vacuum automatically
Дата
Msg-id 87eliydq0a.fsf@papadoc.bayour.com
обсуждение исходный текст
Ответ на Re: Postgresql backend to perform vacuum automatically  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Postgresql backend to perform vacuum automatically  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
>>>>> "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 по дате отправления:

Предыдущее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: Re: Postgresql backend to perform vacuum automatically
Следующее
От: Jean-Paul ARGUDO
Дата:
Сообщение: Re: Drop in performance for each INSERT/DELETE combo