Re: possible vacuum improvement?

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема Re: possible vacuum improvement?
Дата
Msg-id 006601c2531c$9ab9c210$6f01c00a@icomedias.com
обсуждение исходный текст
Ответ на Re: possible vacuum improvement?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Ответы Re: possible vacuum improvement?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: possible vacuum improvement?  (Rod Taylor <rbt@zort.ca>)
Список pgsql-hackers
> gets updated for each transaction but log table is just an insert. So
rather
> than vacumming entire db, just doing 'vacuum analyze accounts' give me
almost
> same results.
>

That is not really practicable, one datebase has 107 tables, and making a
cron job
with 107 vacuum calls is completly out of question and very error prone
anyway.

Regards,   Mario Weilguni




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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: possible vacuum improvement?
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: possible vacuum improvement?