Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 15483862DB6 for ; Wed, 8 Feb 2012 15:44:27 -0400 (AST) Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RvDRJ-0007Jx-9W for pgsql-performance@postgresql.org; Wed, 08 Feb 2012 19:44:27 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q18Ji52w029377; Wed, 8 Feb 2012 14:44:05 -0500 (EST) To: Ofer Israeli cc: "pgsql-performance@postgresql.org" , Netta Kabala , Olga Vingurt Subject: Re: Vacuuming problems on TOAST table In-reply-to: <217DDBC2BB1E394CA9E7446337CBDEF20102C056BFBE@il-ex01.ad.checkpoint.com> References: <217DDBC2BB1E394CA9E7446337CBDEF20102C056BFBE@il-ex01.ad.checkpoint.com> Comments: In-reply-to Ofer Israeli message dated "Wed, 08 Feb 2012 21:33:59 +0200" Date: Wed, 08 Feb 2012 14:44:04 -0500 Message-ID: <29376.1328730244@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/56 X-Sequence-Number: 46228 Ofer Israeli writes: > During our testing we see that the table size increases substantially. When looking at the autovacuum log, set with default configuration, it seems that it ran for around 60 seconds (see below and note that this was a 1-minute test, i.e. only 100 updates)! autovacuum is intended to run fairly slowly, so as to not consume too much resources. If you think it's too slow you can adjust the autovacuum_cost tunables. > When setting a higher cost for the autovacuum, tried values of 2000, it ran for even longer: ~400 seconds! That's the wrong direction, no? regards, tom lane