Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwiTr-0002fk-N0 for pgsql-performance@arkaria.postgresql.org; Wed, 10 Jul 2013 00:42:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UwiTr-0001qY-0E for pgsql-performance@arkaria.postgresql.org; Wed, 10 Jul 2013 00:42:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwiTq-0001qR-7o for pgsql-performance@postgresql.org; Wed, 10 Jul 2013 00:42:02 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwiTk-0003wx-Uu for pgsql-performance@postgresql.org; Wed, 10 Jul 2013 00:42:01 +0000 Received: from [192.168.1.5] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 0128ED0; Tue, 9 Jul 2013 17:41:54 -0700 (PDT) Received: from [192.168.1.5] ([71.95.101.172] helo=[192.168.1.5]) by assp.commandprompt.com with ESMTPS(AES256-SHA) (2.1.1); 9 Jul 2013 17:41:54 -0700 Message-ID: <51DCADC7.4000407@commandprompt.com> Date: Tue, 09 Jul 2013 17:41:43 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130623 Thunderbird/17.0.7 MIME-Version: 1.0 To: Josh Berkus CC: pgsql-performance@postgresql.org Subject: Re: Performance autovaccum References: <51DAE57C.5080503@audifarma.com.co> <51DC8B45.6070704@agliodbs.com> In-Reply-To: <51DC8B45.6070704@agliodbs.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-16914-07819 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: josh@agliodbs.com X-Assp-Original-Subject: Re: [PERFORM] Performance autovaccum X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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