| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Autovacuum on defined interval |
| Date: | 2010-07-20 20:52:37 |
| Message-ID: | 1279658949-sup-5628@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Voinea | 2010-07-21 05:56:14 | Re: Weird sorting order |
| Previous Message | Fábio Gibon - Comex System | 2010-07-20 20:18:44 | Fw: Autovacuum on defined interval |