statistics for shared catalogs not updated when autovacuum is off - Mailing list pgsql-hackers

From Peter Eisentraut
Subject statistics for shared catalogs not updated when autovacuum is off
Date
Msg-id 56AD41AC.1030509@gmx.net
Whole thread Raw
Responses Re: statistics for shared catalogs not updated when autovacuum is off  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
When autovacuum is off, the statistics in pg_stat_sys_tables for shared
catalogs (e.g., pg_authid, pg_database) never update.  So seq_scan
doesn't update when you read the table, last_analyze doesn't update when
you run analyze, etc.

But when you shut down the server and restart it with autovacuum on, the
updated statistics magically appear right away.  So seq_scan is updated
with the number of reads you did before the shutdown, last_analyze
updates with the time of the analyze you did before the shutdown, etc.
So the data is saved, just not propagated to the view properly.

I can reproduce this back to 9.3, but not 9.2.  Any ideas?



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Additional role attributes && superuser review
Next
From: Amit Kapila
Date:
Subject: Re: RFC: replace pg_stat_activity.waiting with something more descriptive