Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkdOw-0003l1-Ms for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 16:18:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TkdOw-0006VO-4h for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 16:18:46 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkdOv-0006VB-Cn for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 16:18:45 +0000 Received: from sd-17937.dedibox.fr ([88.191.100.74]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkdOq-0000lt-ND for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 16:18:44 +0000 Received: from [192.168.1.16] (ATuileries-153-1-35-180.w83-202.abo.wanadoo.fr [83.202.18.180]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id DF28B3B914; Mon, 17 Dec 2012 17:30:02 +0100 (CET) Message-ID: <1355761119.1977.16.camel@localhost.localdomain> Subject: Re: [Autovacuum] Issue to understand some logs From: Guillaume Lelarge To: Baptiste LHOSTE Cc: pgsql-admin@postgresql.org Date: Mon, 17 Dec 2012 17:18:39 +0100 In-Reply-To: <388244443.1761281.1355760618826.JavaMail.root@alaloop.com> References: <388244443.1761281.1355760618826.JavaMail.root@alaloop.com> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.4.4 (3.4.4-2.fc17) Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) 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 Mon, 2012-12-17 at 17:10 +0100, Baptiste LHOSTE wrote: > > It could be dead rows, still visible for other transactions. > > Ok but in this case, why the automatic vacuum task of the autovacuum process does not delete theses dead rows ? > As I said, because they are still visible to other transactions. Try to see if you have long-lasting transactions. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin