| From: | Martín Marqués <martin(dot)marques(at)gmail(dot)com> |
|---|---|
| To: | M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Neeraj Gupta G <neeraj(dot)g(dot)gupta(at)ericsson(dot)com>, Atul Parashar <atul(dot)parashar(at)ericsson(dot)com>, Shishir Singh <shishir(dot)singh(at)globallogic(dot)com>, Ankit Sharma <ankit(dot)sharma10(at)globallogic(dot)com> |
| Subject: | Re: Autovacuum not functioning for large tables but it is working for few other small tables. |
| Date: | 2020-12-16 15:14:49 |
| Message-ID: | CABeG9LvnQ3UNNXnvGXLRvcgocbGNi=7_Cd4y4_=qGr5_bzE5ug@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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 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?
Do you have autovacuum logging enabled in this server? If so, would be
good if you could share them here.
Having the output from logs of autovacuum for these tables would give
some insights on where the problem might reside.
--
Martín Marqués
It’s not that I have something to hide,
it’s that I have nothing I want you to see
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Lewis | 2020-12-16 15:28:04 | Re: Autovacuum not functioning for large tables but it is working for few other small tables. |
| Previous Message | Allan Kamau | 2020-12-16 12:16:14 | Re: protect data of postgres database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Lewis | 2020-12-16 15:28:04 | Re: Autovacuum not functioning for large tables but it is working for few other small tables. |
| Previous Message | M Tarkeshwar Rao | 2020-12-16 11:55:47 | RE: Autovacuum not functioning for large tables but it is working for few other small tables. |