From: Joshua D. Drake <jd@commandprompt.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance autovaccum
Date: Tue, 09 Jul 2013 17:41:43 -0700
Message-ID: <51DCADC7.4000407@commandprompt.com> (raw)
In-Reply-To: <51DC8B45.6070704@agliodbs.com>
References: <51DAE57C.5080503@audifarma.com.co>
<WM!d8cb7563f6cc5f7f5617e82483414f99df84d38f8e1b88a715d8fd743467b1526af5768bd7617c73e12a725a19e48e8d!@asav-2.01.com>
<51DC8B45.6070704@agliodbs.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 07/09/2013 03:14 PM, Josh Berkus wrote:
>
> On 07/08/2013 09:14 AM, Jeison Bedoya wrote:
>> Hi, i have a postgresql 9.2.2, but i don´t use autovaccum but i want to
>> begin to use it. some recommendation about the optimal configuration?
>> or some link to explain it.
>
> Initial configuration:
>
> autovacuum = on
>
> There, you're done. You only do something else if the default
> configuraiton is proven not to work for you.
>
Well, and a restart of PostgreSQL. It should also be noted that
autovacuum by default is on. You can check to see if it is currently
running for you by issuing the following command from psql:
show autovacuum;
Other than that JoshB is correct. The default settings for autovacuum
work for the 95% of users out there.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
a rose in the deeps of my heart. - W.B. Yeats
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: jd@commandprompt.com, josh@agliodbs.com
Subject: Re: Performance autovaccum
In-Reply-To: <51DCADC7.4000407@commandprompt.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