Re: auto truncate/vacuum full

On Tue, Oct 27, 2009 at 6:31 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com>wrote:

> JC Praud escribió:
>
> > So my question are: can the autovacuum daemon perform vacuum full ? Or
> > another internal postgres process ? Could it come from the TRUNCATE I run
> > and canceled 4 days before ?
>
> No. Autovacuum only issues commands that don't lock tables strongly. I
> doubt this has anything to do with your old TRUNCATE either. My guess
> is that somebody else ran TRUNCATE and forgot to tell you; or maybe an
> automatic external process (cron or some such).
>

I suspected that, too. And asked the ninjas we have here ;) I also checked
the vacuum cronjobs we have.
None performing full vacuum on this table.
If it was the case, I should have seen the query in the pg_log as a slow
query, I guess ?

Regards,

>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

--
JC
Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn!