The following bug has been logged online: Bug reference: 5722 Logged by: Jochen Erwied Email address: joc...@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 | -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs