Postgres Pro
Downloads
Home   >   mailing lists

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

From M Tarkeshwar Rao
Subject RE: Autovacuum not functioning for large tables but it is working for few other small tables.
Date
Msg-id AM6PR0702MB3783AE08F338E43BE1D82914AEC50@AM6PR0702MB3783.eurprd07.prod.outlook.com
Whole thread Raw
Responses Re: Autovacuum not functioning for large tables but it is working for few other small tables.  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-performance
Tree view

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 functioning correctly for  table_B which have a large size(100+GB) in comparision to table_A.

 

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 server.

 

Is autovacuum not working against large sized tables or Is there any parameters which  need to set to make autovacuum functioning?

 

Any suggestions?

 

Regards

Tarkeshwar

 

 

pgsql-performance by date:

Previous
From: Sebastijan Wieser
Date:
Subject: Performance issues with composite types (partitioned table)
Next
From: Tomas Vondra
Date:
Subject: Re: Autovacuum not functioning for large tables but it is working for few other small tables.