Re: Distinguishing autovacuum activity in pg_stat_activity

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Distinguishing autovacuum activity in pg_stat_activity
Date: 2008-01-13 22:41:57
Message-ID: 478A93B5.6010406@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Guillaume Smet wrote:
> On Jan 13, 2008 11:27 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>> AUTOVACUUM ANALYZE foo.bar more clear.
>
> Doesn't autovacuum also trigger ANALYZE only?
>
> That's why I proposed an 'autovacuum:' prefix.

Oh so:

autovacuum: vacuum
autovacuum: analyze
autovacuum: vacuum analyze

Yeah that's cool.

Joshua D. Drake

>
> --
> Guillaume
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-01-13 23:52:42 Re: Index trouble with 8.3b4
Previous Message Guillaume Smet 2008-01-13 22:38:48 Re: Distinguishing autovacuum activity in pg_stat_activity