Alvaro Herrera <alvherre@commandprompt.com> writes:
> Hmm, as far as I can tell, the database entry would not be created
> merely by a vacuum. The only way to create a database entry in pgstat
> is by calling pgstat_recv_tabstat(); and pgstat_report_tabstat is only
> called in postgres.c (not invoked via autovacuum) and in
> pgstat_beshutdown_hook (not sure if this one is).
The shutdown hook surely is called, and the scenario for sending stats
seems pretty obvious: stats_block_level = ON.
> Maybe we could forcibly activate the freeze mode on a template database?
Might not be a bad idea. And even more to the point, forcibly disable
analyze.
regards, tom lane