Обсуждение: AutoVacuum Daemon
Hi, I want know if I should run the auto-vacuum daemon (from /etc/init.d/) or it runs automatically and transparently if configured in postgres.conf?. If it must be configured manually, what is the script to be run, I didn't find pg_autovacuum or similar. I didn't find information about this on this page: http://www.postgresql.org/docs/8.4/static/routine-vacuuming.html#AUTOVACUUM P.S.: I'm on linux running PostgreSql 8.4 Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 351 6629292
On 30 December 2013 19:11 Leonardo M. Ramé wrote: > Hi, I want know if I should run the auto-vacuum daemon (from > /etc/init.d/) or it runs automatically and transparently if configured > in postgres.conf?. If it must be configured manually, what is the > script to be run, I didn't find pg_autovacuum or similar. > > I didn't find information about this on this page: > > http://www.postgresql.org/docs/8.4/static/routine- > vacuuming.html#AUTOVACUUM > > P.S.: I'm on linux running PostgreSql 8.4 Just enable "autovacuum" configuration parameter in postgresql.conf file. Which internally spawns an autovacuum process which will take care of vacuuming. Regards, Hari babu.
On 2013-12-30 13:45:43 +0000, Haribabu kommi wrote: > On 30 December 2013 19:11 Leonardo M. Ramé wrote: > > Hi, I want know if I should run the auto-vacuum daemon (from > > /etc/init.d/) or it runs automatically and transparently if configured > > in postgres.conf?. If it must be configured manually, what is the > > script to be run, I didn't find pg_autovacuum or similar. > > > > I didn't find information about this on this page: > > > > http://www.postgresql.org/docs/8.4/static/routine- > > vacuuming.html#AUTOVACUUM > > > > P.S.: I'm on linux running PostgreSql 8.4 > > Just enable "autovacuum" configuration parameter in postgresql.conf file. > Which internally spawns an autovacuum process which will take care of vacuuming. > Thanks, that's easier than I thought. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 351 6629292
On Mon, Dec 30, 2013 at 11:02 PM, Leonardo M. Ramé <l.rame@griensu.com> wrote: > On 2013-12-30 13:45:43 +0000, Haribabu kommi wrote: >> On 30 December 2013 19:11 Leonardo M. Ramé wrote: >> > Hi, I want know if I should run the auto-vacuum daemon (from >> > /etc/init.d/) or it runs automatically and transparently if configured >> > in postgres.conf?. If it must be configured manually, what is the >> > script to be run, I didn't find pg_autovacuum or similar. >> > >> > I didn't find information about this on this page: >> > >> > http://www.postgresql.org/docs/8.4/static/routine- >> > vacuuming.html#AUTOVACUUM >> > >> > P.S.: I'm on linux running PostgreSql 8.4 >> >> Just enable "autovacuum" configuration parameter in postgresql.conf file. >> Which internally spawns an autovacuum process which will take care of vacuuming. >> > > Thanks, that's easier than I thought. This parameter is on by default since 8.3, so you don't really need to touch it yourself normally. Regards, -- Michael