G ; Atul Parashar
; Shishir Singh ;
Ankit Sharma
Subject: Re: Autovacuum not functioning for large tables but it is working for
few other small tables.
On 12/16/20 12:55 PM, M Tarkeshwar Rao wrote:
> Hi all,
>
> We have facing some discrepancy in Postgresql database relat
On Wed, Dec 16, 2020 at 6:55 AM M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
> ...
>
>
> All the threshold level requirements for autovacuum was meet and there are
> about Million’s of dead tuples but autovacuum was unable to clear them,
> which cause performance issue on production
Absolutely check the logs, or do a manual vacuum verbose with setting cost
delay and cost limit (and maintenance work mem) the same as the values for
auto vacuum runs. It should work out the same and you could time it for a
period when the system is more lightly used it applicable.
If you have man
Hi,
> We have facing some discrepancy in Postgresql database related to the
> autovacuum functionality.
>
> By default autovacuum was enable on Postgres which is used to remove the dead
> tuples from the database.
>
> We have observed autovaccum cleaning dead rows from table_A but same was not
Hi all,
We have facing some discrepancy in Postgresql database related to the
autovacuum functionality.
By default autovacuum was enable on Postgres which is used to remove the dead
tuples from the database.
We have observed autovaccum cleaning dead rows from table_A but same was not
functioni
