Alvaro Herrera a écrit : > Kevin Kempter wrote: > [...] >> b) a list of tables in the db and the last time they were vacuumed > > Examine the pg_stat views, though I am not sure if the vacuum columns > were already in 8.1. In any case, in 8.1 Xid wraparound is tracked > per-database, so you need database-wide vacuums. In 8.2 it is per table > so it is easier to keep up to date. > last vacuum information is available on 8.2, not 8.1. See http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html Regards. -- Guillaume. <!-- http://abs.traduc.org/ http://lfs.traduc.org/ http://docs.postgresqlfr.org/ --> ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
