Re: Autovacuum not functioning for large tables but it is working for few other small tables.

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Autovacuum not functioning for large tables but it is working for few other small tables.
Дата
Msg-id CAHOFxGpokCR7rNB4CUkDcLGR1OXXs=RW0Wc1mGb6fwqca45L-w@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Autovacuum not functioning for large tables but it is working for few other small tables.  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
Список pgsql-performance
Дерево обсуждения
By the way, please do not top-post (reply above, quoting the full email after) in these groups.


On Fri, Jan 8, 2021 at 5:00 AM M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com> wrote:
Hi all,

As we know, the VACUUM VERBOSE output has a lot of dependencies from production end and is indefinite as of now.

What do you mean by this statement?
 
We don’t have any clue till now on why exactly the auto-vacuum is not working for the table. So we need to have a work around to move ahead for the time being.

Can you please suggest any workaround so that we can resolve the issue or any other way by which we can avoid this situation?

Have you tried any of the suggestions already given 3+ weeks ago? Do you have answers to any of the questions posed by me or the other three people who responded?

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

Предыдущее
От: M Tarkeshwar Rao
Дата:
Сообщение: RE: Autovacuum not functioning for large tables but it is working for few other small tables.
Следующее
От: José Arthur Benetasso Villanova
Дата:
Сообщение: Re: High COMMIT times