Re: [ADMIN] pg_stat_activity reporting of VACUUM in 8.1

2009-07-24 Thread Alvaro Herrera
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,

[ADMIN] pg_stat_activity reporting of VACUUM in 8.1

2009-07-23 Thread Kevin Kempter
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 t