From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: isabella.ghiurea@nrc-cnrc.gc.ca
Cc: pgsql-admin@postgresql.org
Subject: Re: autovacuum questions
Date: Fri, 31 Oct 2008 14:32:45 -0100
Message-ID: <3a0028490810310832t2972fb95l6c8d01e7895c1b6c@mail.gmail.com> (raw)
In-Reply-To: <490B2161.1070502@nrc-cnrc.gc.ca>
References: <490B2161.1070502@nrc-cnrc.gc.ca>
Hello there,
Yes, the autovacuum is set on by default on the PG 8.3.
The vacuum is not full, to run a full vacuum you need to set a cron job;
better to run at the night.
I don't set autovacuum on the production databases, only in the Slony's
slave machines and in the developmente machine.
For autovacuum settings you need to set and see if it's ok for you.
to see if the vacuum is running you can use the command "ps axf | grep
postgres" on the linux server. Sometimes autovacuum is so fast that you even
notice him.
I hope that I helped
Best Regards,
Rafael Domiciano
2008/10/31 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
> Hello Gurus,
> I'm new to PG , running PG 8.3 on Linux and reading trough docs is
> mentioned that in PG vers 8.3 an AUTO vacuum process has been implemented
> which will run
> full vacuum on all user and system tables + analyze and there is NO
> need fro DBA to schedule a crontab job to run this maintenance jobs . If
> this is true , here are my questions :
> Would like to know from your experience is this automated process
> sufficient and reliable in a warehouse database , can I rely only on this
> internal process ?
> How can I see when the job has been run or completed by PG ?
> I have configure track_count=true, what values should I go for
> autovacuum_naptime from your experience?
>
> Isabella
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rafael.domiciano@gmail.com, isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: autovacuum questions
In-Reply-To: <3a0028490810310832t2972fb95l6c8d01e7895c1b6c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox