Thread: Autovacuum on defined interval
Hi everybody,
are there how define autovacuum to ON and define the period time (for example, 00h - 06h) that it's can run?
tks
Fábio Henrique Gibon
Comex System Consultoria
On Tue, 2010-07-20 at 13:20 -0300, Fábio Gibon - Comex System wrote: > Hi everybody, > are there how define autovacuum to ON and define the period > time (for example, 00h - 06h) that it's can run? > No. You would need to write your own job manager (or use one of the many that already exist) and vacuum via it. JD > tks > > Fábio Henrique Gibon > Comex System Consultoria -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering
Excerpts from Fábio Gibon - Comex System's message of mar jul 20 12:20:36 -0400 2010: > Hi everybody, > are there how define autovacuum to ON and define the period time (for example, 00h - 06h) that it's can run? You could have a script that toggles the value in postgresql.conf and do a Postgres reload, and run that script in cron.
Excerpts from Fábio Gibon - Comex System's message of mar jul 20 16:13:39 -0400 2010: > Perfect!!! > > I'm starting with PostgreSQL (my knowledge is Oracle). Can you explain more > about autovacuum? for example... > 1 - on windows SO, autovacuum start works (postgres.exe as > autovacuum_max_workers) ? I think questions (1) and (2) are best answered in the docs: http://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM Please have a read and let us know if you have further questions. > 3 - on autovacuum is executed vacuum with FULL option or not? No, by design autovacuum never invokes any blocking activity. > 4 - if autovacuum is running and i do a reload config setting autovacuum off > this process will be down? The launcher will be shut down, but any worker currently processing tables will continue until finished with its tables.
On Tue, 2010-07-20 at 13:20 -0300, Fábio Gibon - Comex System wrote: > Hi everybody, > are there how define autovacuum to ON and define the period > time (for example, 00h - 06h) that it's can run? > No. You would need to write your own job manager (or use one of the many that already exist) and vacuum via it. JD > tks > > Fábio Henrique Gibon > Comex System Consultoria -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering