Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TG7h3-0001BD-1E for pgsql-performance@postgresql.org; Mon, 24 Sep 2012 12:23:21 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TG7gx-0006vo-N8 for pgsql-performance@postgresql.org; Mon, 24 Sep 2012 12:23:20 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TG7gv-0007Gm-KW for pgsql-performance@postgresql.org; Mon, 24 Sep 2012 05:23:13 -0700 Date: Mon, 24 Sep 2012 05:23:13 -0700 (PDT) From: MirrorX To: pgsql-performance@postgresql.org Message-ID: <1348489393630-5725129.post@n5.nabble.com> In-Reply-To: <71DC95CE-16EF-4D53-9971-C573DCD30622@gmail.com> References: <71DC95CE-16EF-4D53-9971-C573DCD30622@gmail.com> Subject: Re: Postgres becoming slow, only full vacuum fixes it MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.9 (/) X-Archive-Number: 201209/112 X-Sequence-Number: 47858 i remember having a server with 8.4.4 where we had multiple problems with autovacuum. if i am not mistaken there are some bugs related with vacuum until 8.4.7. i would suggest you to upgrade to the latest 8.4.x version BR, -- View this message in context: http://postgresql.1045698.n5.nabble.com/Postgres-becoming-slow-only-full-vacuum-fixes-it-tp5725119p5725129.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.