Re: Distinguishing autovacuum activity in pg_stat_activity - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Distinguishing autovacuum activity in pg_stat_activity
Date
Msg-id 20080114003105.GB17558@alvh.no-ip.org
Whole thread Raw
In response to Re: Distinguishing autovacuum activity in pg_stat_activity  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Responses Re: Distinguishing autovacuum activity in pg_stat_activity
Re: Distinguishing autovacuum activity in pg_stat_activity
List pgsql-hackers
Guillaume Smet escribió:
> On Jan 13, 2008 10:59 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > I think this would be a helpful change, but some might find it
> > confusing.  Thoughts?
> 
> If possible, something like:
> autovacuum: VACUUM ANALYZE foo.bar
> could be less confusing.
> It's weird to just add AUTO in front of the query.

Whether the string is "AUTO " or "autovacuum: " seems rather the same
thing to me :-)  I agree with the general idea.  I think "autovacuum: "
makes it clearer that it's not part of the actual command syntax, so
maybe I'll put half a vote for that option.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index trouble with 8.3b4
Next
From: "Guillaume Smet"
Date:
Subject: Re: Distinguishing autovacuum activity in pg_stat_activity