The following bug has been logged online:
Bug reference: 5722
Logged by: Jochen Erwied
Email address: jochen@pgsql.erwied.eu
PostgreSQL version: 9.0.1
Operating system: x86_64-pc-linux-gnu
Description: vacuum full does not update last_vacuum statistics
Details:
VACUUM FULL does not update statistics so display of pg_stat_user_tables is
wrong. A normal VACUUM updates the relevant information.
Example on a live database:
smtpscan=# select * from pg_stat_all_tables where
relname='servers_part_226';
-[ RECORD 1 ]----+------------------------------
relid | 30559
schemaname | public
relname | servers_part_226
seq_scan | 38
seq_tup_read | 38
idx_scan | 0
idx_tup_fetch | 0
n_tup_ins | 1
n_tup_upd | 0
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1
n_dead_tup | 0
last_vacuum |
last_autovacuum |
last_analyze | 2010-10-25 14:17:20.013568+02
last_autoanalyze |
smtpscan=# vacuum full servers_part_226;
VACUUM
smtpscan=# select * from pg_stat_all_tables where
relname='servers_part_226';
-[ RECORD 1 ]----+------------------------------
relid | 30559
schemaname | public
relname | servers_part_226
seq_scan | 42
seq_tup_read | 42
idx_scan | 0
idx_tup_fetch | 0
n_tup_ins | 1
n_tup_upd | 0
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1
n_dead_tup | 0
last_vacuum |
last_autovacuum |
last_analyze | 2010-10-25 14:17:20.013568+02
last_autoanalyze |
smtpscan=# vacuum servers_part_226;
VACUUM
smtpscan=# select * from pg_stat_all_tables where
relname='servers_part_226';
-[ RECORD 1 ]----+------------------------------
relid | 30559
schemaname | public
relname | servers_part_226
seq_scan | 42
seq_tup_read | 42
idx_scan | 0
idx_tup_fetch | 0
n_tup_ins | 1
n_tup_upd | 0
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 1
n_dead_tup | 0
last_vacuum | 2010-10-25 14:41:18.67515+02
last_autovacuum |
last_analyze | 2010-10-25 14:17:20.013568+02
last_autoanalyze |