| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Don Seiler <don(at)seiler(dot)us>, Phil Frost <phil(at)postmates(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Why is my table not autovacuuming? |
| Date: | 2017-08-28 16:13:03 |
| Message-ID: | 73557173-6cdb-6318-c7a5-e531d385e397@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 08/28/2017 08:59 AM, Don Seiler wrote:
> So the autovacuum daemon knows that there are 71M rows, even though
> pg_stat_all_tables said only 170K? Is it using pg_class.reltuples? Is
> pg_stat_all_tables not really a reliable source of stats information?
See:
file:///opt/src/pgsql-git/master/src/backend/postmaster/autovacuum.c
* threshold = vac_base_thresh + vac_scale_factor * reltuples
pg_stat_all_tables only shows information known by the stats collector,
which only knows about activity since the last stats reset (which can
happen, for example on "immediate" shutdown or server crash), not
absolute numbers (although reltuples is only an estimate too).
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Seiler | 2017-08-28 16:16:30 | Re: Why is my table not autovacuuming? |
| Previous Message | Don Seiler | 2017-08-28 16:12:58 | Re: Why is my table not autovacuuming? |