Alvaro Herrera <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
