Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkdLW-0003i5-Bg for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 16:15:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TkdLU-0005IH-Nr for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 16:15:12 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkdGn-000581-Hp for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 16:10:21 +0000 Received: from mx0.network-studio.com ([62.93.225.99]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkdGl-0000g4-Nc for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 16:10:20 +0000 Received: from zimbra-ne01.network-studio.com (zimbra-admin.network-studio.com [192.168.101.80]) by mx0.network-studio.com (Postfix) with ESMTP id 2F64740812C; Mon, 17 Dec 2012 17:10:19 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by zimbra-ne01.network-studio.com (Postfix) with ESMTP id 29DC2DA1332; Mon, 17 Dec 2012 17:10:19 +0100 (CET) X-Virus-Scanned: amavisd-new at zimbra-ne01.network-studio.com Received: from zimbra-ne01.network-studio.com ([127.0.0.1]) by localhost (zimbra-ne01.network-studio.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id U7ETPyG+err9; Mon, 17 Dec 2012 17:10:18 +0100 (CET) Received: from zimbra-ne01.network-studio.com (zimbra-ne01.network-studio.com [192.168.101.80]) by zimbra-ne01.network-studio.com (Postfix) with ESMTP id D8095DA12DF; Mon, 17 Dec 2012 17:10:18 +0100 (CET) Date: Mon, 17 Dec 2012 17:10:18 +0100 (CET) From: Baptiste LHOSTE To: Guillaume Lelarge Cc: pgsql-admin@postgresql.org Message-ID: <388244443.1761281.1355760618826.JavaMail.root@alaloop.com> In-Reply-To: <1355760173.1977.14.camel@localhost.localdomain> Subject: Re: [Autovacuum] Issue to understand some logs MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Originating-IP: [192.168.101.82] X-Mailer: Zimbra 7.2.1_GA_2790 (ZimbraWebClient - GC23 (Linux)/7.2.1_GA_2790) 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 > It could be dead rows, still visible for other transactions. Ok but in this case, why the automatic vacuum task of the autovacuum proces= s does not delete theses dead rows ?=20 Best regards, Baptiste ---=20 Baptiste LHOSTE=20 blhoste@alaloop.com=20 ALALOOP S.A.S. - Technopole Izarbel - 64210 Bidart=20 T=C3=A9l=C3=A9phone : +33 (0) 5 59 41 51 10=20 www.alaloop.com=20 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin