Fw: Autovacuum on defined interval
Fw: Autovacuum on defined interval
От:
Fábio Gibon - Comex System <gibon@comexsystem.com.br>
Дата:
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" > To: "Fábio Gibon - Comex System" > 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. >> >