Re: [GENERAL] A few basic troubleshooting questions

2007-09-25 Thread Erik Jones
On Sep 25, 2007, at 9:29 AM, Kevin Kempter wrote: Hi List; I have a few basic troubleshooting questions... 1) If I have autovacuum turned on, how do I know which table is being vacuumed when in pg_stat_activity I only see VACUUM? I've been using this query but it doesn't always work...

[GENERAL] A few basic troubleshooting questions

2007-09-25 Thread Kevin Kempter
Hi List; I have a few basic troubleshooting questions... 1) If I have autovacuum turned on, how do I know which table is being vacuumed when in pg_stat_activity I only see VACUUM? I've been using this query but it doesn't always work... is there a better way? CREATE Temp table tmp_p as SELECT