Search Postgresql Archives

Re: AutoVacuum on demand?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Glen Parker wrote:
> Matthew T. O'Connor wrote:
> >Glen Parker wrote:
> >>I would like a way to run the autovacuum daemon on demand 
> >>periodically.   Every night at 2 AM, for example.
> >>
> >>Anybody know if this is possible?  If not, it's a feature request :-)
> >
> >Autovacuum can be enabled / disabled on the fly using the GUC settings.  
> >Perhaps you can write a cron script that runs at 2AM that enables 
> >autovac, and at 6AM (just a guess) disables it in the same fashion.  I 
> >think that should work.
> >
> >Would be curious to hear your results.
> 
> I thought it sounded like a good idea, but then...
> 
> SET autovacuum = on;
> ERROR:  parameter "autovacuum" cannot be changed now

I think the idea is to edit the postgresql.conf file on the fly and send
a SIGHUP to the postmaster.  I haven't ever heard of anyone doing that,
but I don't see any reason why it wouldn't work.

I'm not sure if the version you are running supports "include"
directives in postgresql.conf (heck, I'm not even sure if it's possible
to do in 8.2); if that's the case, then it's considerably easier.

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux