Re: Why is my table not autovacuuming?

Good to know, thanks very much!

Don.

On Mon, Aug 28, 2017 at 11:13 AM, Joe Conway <mail(at)joeconway(dot)com> wrote:

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

--
Don Seiler
www.seiler.us