Yes, i could do that but it seems simpler (to me) with a trigger than
looking at the recent changes records and store them somewhere.
ste
Alvaro Herrera wrote:
Stefano Nichele escribió:
Hi All,
in pg_stat_all_tables, the fields last_autovacuum, last_autoanalyze are
updated any time autovacuum vacuums a table.
I would like to keep an history of these activities in order to see when
and how many times any single table is vacuumed.
Is there any features that can help me ? (I'm using postgres 8.2.9)
What about creating a trigger on pg_stat_all_tables and storing the
required info in another table (like autovacuum_history) ?
I guess you could run a query once every autovacuum_naptime and have it
save aside all those entries from pg_stat_all_tables that have recent
dates into a history table.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
