Kevin Kempter wrote: > Hi all; > > looking at a system running 8.1.15 > via a select from pg_stat_activity I see a row where the vcurrent_query = > 'VACUUM' > > I see also that autovacuum is on. Would autovacuum be running a vacuum on the > entire db? I didn't think autovacuum did that. If not, how do I know in > version 8.1 what table is being vacuumed? I thought that even in 8.1 the > current_query column in pg_stat_activity would list the full sql being run as > opposed to 'VACUUM'. It might need to run database wide vacuum in case of transaction wraparound. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
