Re: AutoVacuum Daemon

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com>
Cc: Haribabu kommi <haribabu(dot)kommi(at)huawei(dot)com>, PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: AutoVacuum Daemon
Date: 2014-01-07 12:46:01
Message-ID: CAB7nPqTy39dCjsfKqxfv-Wb+2n62DTF8ViYen6fnBMnWw7bV9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 30, 2013 at 11:02 PM, Leonardo M. Ramé <l(dot)rame(at)griensu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2014-01-07 12:51:32 Re: question on parallelism
Previous Message ambilalmca 2014-01-07 12:33:20 How to know server status variable in postgresql?