Re: Postgresql backend to perform vacuum automatically

Поиск
Список
Период
Сортировка
От Turbo Fredriksson
Тема Re: Postgresql backend to perform vacuum automatically
Дата
Msg-id 87n0xl3c1k.fsf@papadoc.bayour.com
обсуждение исходный текст
Ответ на 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:
   Bruce> Turbo Fredriksson wrote:   >> >>>>> "Bruce" == Bruce Momjian <pgman@candle.pha.pa.us> writes:   >>    >> >>
Arethere 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
infois around, I could whip up something pretty   >> easily, >> I think.   >>    Bruce> Sure, Jan's new statistics
tablesin 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]


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Turbo Fredriksson
Дата:
Сообщение: Re: Drop in performance for each INSERT/DELETE combo
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Weird WAL numbering