Is it ok to run vacuum full verbose command for live database for thetables which has more dead tuples?

Поиск
Список
Период
Сортировка
От Raghavendra Rao J S V
Тема Is it ok to run vacuum full verbose command for live database for thetables which has more dead tuples?
Дата
Msg-id CAEHH7R7f9oQauDNLsOZ4BO_Yi7icP_n6SxChQj69ROsX0FuGOg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Is it ok to run vacuum full verbose command for live database forthe tables which has more dead tuples?
Re: Is it ok to run vacuum full verbose command for live database forthe tables which has more dead tuples?
Список pgsql-general
Дерево обсуждения
We have thousands of tables. But out of those tables, around 20 to 40 tables are always busy due to that those tables are bloating.

In order to avoid this we are running a shell script which performs vacuum full on the tables which has more than ten thousand dead tuples. While running this we are stopping all application processors and running vacuum full on the tables which has more dead tuples.

  1. Is it ok to run vacuum full verbose command for live database for the tables which has more dead tuples(greater than)?
  2. Does it cause any adverse effect?

Please clarify me. Thanks in advance.

--
Regards,
Raghavendra Rao J S V

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

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Shared buffers increased but cache hit ratio is still 85%
Следующее
От: Hans Schou
Дата:
Сообщение: Re: Shared buffers increased but cache hit ratio is still 85%