Re: Autovacuum not functioning for large tables but it is working for few other small tables. - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Autovacuum not functioning for large tables but it is working for few other small tables.
Date
Msg-id CAHOFxGpokCR7rNB4CUkDcLGR1OXXs=RW0Wc1mGb6fwqca45L-w@mail.gmail.com
Whole thread Raw
In response to RE: Autovacuum not functioning for large tables but it is working for few other small tables.  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
List 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 by date:

Previous
From: M Tarkeshwar Rao
Date:
Subject: RE: Autovacuum not functioning for large tables but it is working for few other small tables.
Next
From: José Arthur Benetasso Villanova
Date:
Subject: Re: High COMMIT times