From: | "Jochen Erwied" <jochen(at)pgsql(dot)erwied(dot)eu> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5722: vacuum full does not update last_vacuum statistics |
Date: | 2010-10-25 12:42:24 |
Message-ID: | 201010251242.o9PCgO10001534@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5722
Logged by: Jochen Erwied
Email address: jochen(at)pgsql(dot)erwied(dot)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 |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-25 14:12:39 | Re: BUG #5722: vacuum full does not update last_vacuum statistics |
Previous Message | Heikki Linnakangas | 2010-10-25 11:44:37 | Re: Recovery bug |