From: | Don Seiler <don(at)seiler(dot)us> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Why is my table not autovacuuming? |
Date: | 2017-08-28 15:43:07 |
Message-ID: | CAHJZqBAaXKi2+n4zNFYkjOCLY+ABpuC_BSMBKHfHfs0QqPNjbA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
PostgreSQL 9.2.18. I have a table with 71M rows (via select count). In
pg_stat_activity, n_live_tups is 170K, n_dead_tups is slightly more than
that (203K). The autovacuum parameter is on, the scale factor is 0.2
(default) and threshold is 50 (default), autovacuum_max_workers is 3. There
are no custom autovacuum thresholds set for this table. The last_autovacuum
field is null.
Obviously I would expect autovacuum/autoanalyze to kick in for this table
so the stats aren't getting so far out of whack from reality. When I query
pg_stat_activity, I never see any autovacuum jobs running, so it isn't a
matter of too much work from what I can tell.
Previously I had tables not being autovacuumed because of index corruption
(which would also cause manual vacuum to fail), but I was just able to
successfully vacuum this table manually and now pg_stat_activity show the
accurate info.
Wondering why my autovacuum daemon appears to be acting lazily?
Don.
--
Don Seiler
www.seiler.us
From | Date | Subject | |
---|---|---|---|
Next Message | António Silva | 2017-08-28 15:54:03 | Error FATAL: invalid frontend message type 21 |
Previous Message | David G. Johnston | 2017-08-28 15:20:15 | Re: Some questions on PostgreSQL 9.6 JSONB |