Not quite a performance question, but I can't seem to find a simple answer to this. We're using 8.1.4 and the autovacuum daemon is running every 40 seconds cycling between 3 databases. What is the easiest way to disable the autovacuumer for a minute or two, do some other work, then re-enable it? Do I have to modify postgresql.conf and send a HUP signal to pick up the changes?
I figured this would work but I can't find a reason why not: # show autovacuum; autovacuum ------------ on (1 row) # set autovacuum to off; ERROR: parameter "autovacuum" cannot be changed now In postgresql.conf: autovacuum = on Thanks, Steve
