AutoVacuum Daemon

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general