pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAutovacuum on defined interval
5+ messages / 3 participants
[nested] [flat]
* Autovacuum on defined interval
@ 2010-07-20 16:20 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
0 siblings, 2 replies; 5+ messages in thread
From: Fábio Gibon - Comex System @ 2010-07-20 16:20 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Autovacuum on defined interval
@ 2010-07-20 17:03 Joshua D. Drake <jd@commandprompt.com>
parent: Fábio Gibon - Comex System <gibon@comexsystem.com.br>
1 sibling, 0 replies; 5+ messages in thread
From: Joshua D. Drake @ 2010-07-20 17:03 UTC (permalink / raw)
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Autovacuum on defined interval
@ 2010-07-20 19:10 Alvaro Herrera <alvherre@commandprompt.com>
parent: Fábio Gibon - Comex System <gibon@comexsystem.com.br>
1 sibling, 1 reply; 5+ messages in thread
From: Alvaro Herrera @ 2010-07-20 19:10 UTC (permalink / raw)
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Fw: Autovacuum on defined interval
@ 2010-07-20 20:18 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
0 siblings, 0 replies; 5+ messages in thread
From: Fábio Gibon - Comex System @ 2010-07-20 20:18 UTC (permalink / raw)
To: pgsql-admin
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) ?
2 - what moment autovacuum check se necessary run or not? (when ocurred dml
statament ?)
3 - on autovacuum is executed vacuum with FULL option or not?
4 - if autovacuum is running and i do a reload config setting autovacuum off
this process will be down?
thanks again...
Fábio Gibon
> ----- Original Message -----
> From: "Alvaro Herrera" <alvherre@commandprompt.com>
> To: "Fábio Gibon - Comex System" <gibon@comexsystem.com.br>
> Sent: Tuesday, July 20, 2010 4:55 PM
> Subject: Re: [ADMIN] Autovacuum on defined interval
>
>
>> Excerpts from Fábio Gibon - Comex System's message of mar jul 20
>> 15:18:06 -0400 2010:
>>> thanks for your reply... but i can't shutdown database (24/7)
>>
>> I didn't say shutdown. A reload does not kill existing connections.
>>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Autovacuum on defined interval
@ 2010-07-20 20:52 Alvaro Herrera <alvherre@commandprompt.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 5+ messages in thread
From: Alvaro Herrera @ 2010-07-20 20:52 UTC (permalink / raw)
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-07-20 20:52 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-20 16:20 Autovacuum on defined interval Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2010-07-20 17:03 ` Joshua D. Drake <jd@commandprompt.com>
2010-07-20 19:10 ` Alvaro Herrera <alvherre@commandprompt.com>
2010-07-20 20:52 ` Alvaro Herrera <alvherre@commandprompt.com>
2010-07-20 20:18 Fw: Autovacuum on defined interval Fábio Gibon - Comex System <gibon@comexsystem.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox