Fw: Autovacuum on defined interval
От | Fábio Gibon - Comex System |
---|---|
Тема | Fw: Autovacuum on defined interval |
Дата | |
Msg-id | 007201cb2848$c21c6bf0$6500a8c0@gibon обсуждение исходный текст |
Список | 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. >> >
В списке pgsql-admin по дате отправления: