Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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
