Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZHk4s-0005w7-Ph for pgsql-admin@arkaria.postgresql.org; Wed, 22 Jul 2015 02:48:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZHk4r-0002wl-IW for pgsql-admin@arkaria.postgresql.org; Wed, 22 Jul 2015 02:48:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZHk3H-000135-1O for pgsql-admin@postgresql.org; Wed, 22 Jul 2015 02:46:35 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ZHk3B-0001RQ-94 for pgsql-admin@postgresql.org; Wed, 22 Jul 2015 02:46:32 +0000 Received: from [192.168.1.3] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 3C91649F; Tue, 21 Jul 2015 19:46:26 -0700 (PDT) Received: from [192.168.1.3] ([67.168.169.165] helo=[192.168.1.3]) by assp.commandprompt.com with ESMTPS(AES128-SHA) (2.1.1); 21 Jul 2015 19:46:25 -0700 Message-ID: <55AF0402.2060103@commandprompt.com> Date: Tue, 21 Jul 2015 19:46:26 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.8.0 MIME-Version: 1.0 To: Wei Shan , pgsql-admin Subject: Re: Auto Vacuum Daemon not running even though it's been configured References: In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-33186-06654 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-admin@postgresql.org X-Assp-Original-Subject: Re: [ADMIN] Auto Vacuum Daemon not running even though it's beenconfigured X-Pg-Spam-Score: -3.1 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 07/21/2015 07:16 PM, Wei Shan wrote: > > > > Any advice please? 1. Get the heck off 9.2.4 (9.2.13 is the recommended version) 2. Try analyzing the database and then doing a large update on a test table 3. report back results. > > Thanks! > > > -- > Regards, > Ang Wei Shan -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin