Can postgres run autovacuum tasks when autovacuum is disabled?

From: Andrey Zhidenkov <pensnarik(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Can postgres run autovacuum tasks when autovacuum is disabled?
Date: 2014-07-30 07:12:21
Message-ID: CAN=gQ4AnP5mQHiU_2YYNDmCps=E3pGXQyAeAQ7RySEURri0V0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs

I'm confused about this:

[postgres(at)srv log]$ grep autovacuum ~/data/postgresql.conf
autovacuum = off # Enable autovacuum subprocess? 'on'
log_autovacuum_min_duration = 0 # -1 disables, 0 logs all actions and
autovacuum_naptime = 10min # time between autovacuum runs

So, as you can see, autovacuum is disabled now and I could not seen any
autovacuum tasks about few hours. But now
I can see this:

srv=# select backend_start, query from pg_stat_activity where query ilike
'%vacuum%';
backend_start | query

-------------------------------+---------------------------------------------------------------------------------
2014-07-29 21:38:42.882383+04 | select backend_start, query from
pg_stat_activity where query ilike '%vacuum%';
2014-07-30 10:21:51.5511+04 | autovacuum: VACUUM ANALYZE customer_email
2014-07-30 10:43:19.49936+04 | autovacuum: VACUUM ANALYZE cdr_tech
(3 rows)

The problem is that table cdr_tech is very large (70Gb) and I couldn't wait
while autovacuum is finished, I would like to run vacuum manually at night
time.

Whan I do wrong?

Best regards, Andrey Zhidenkov

_
ASCII ribbon campaign ( )
against HTML e-mail X
/ \

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G Johnston 2014-07-30 07:39:02 Re: Can postgres run autovacuum tasks when autovacuum is disabled?
Previous Message Rural Hunter 2014-07-30 04:16:36 Re: Very slow planning performance on partition table

Browse pgsql-bugs by date

  From Date Subject
Next Message David G Johnston 2014-07-30 07:39:02 Re: Can postgres run autovacuum tasks when autovacuum is disabled?
Previous Message David G Johnston 2014-07-30 03:31:01 Re: BUG #11090: Unclear error message in pg_upgrade