Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkdfF-000438-8L for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 16:35:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TkdfE-0002lm-Ov for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 16:35:36 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkdfD-0002kQ-2r for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 16:35:35 +0000 Received: from mx0.network-studio.com ([62.93.225.99]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tkdf6-00013B-Hr for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 16:35:34 +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 C032C408127; Mon, 17 Dec 2012 17:35:27 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by zimbra-ne01.network-studio.com (Postfix) with ESMTP id BA9BBDA1AD4; Mon, 17 Dec 2012 17:35:27 +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 i1hLuGmglpvH; Mon, 17 Dec 2012 17:35:27 +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 88CE7DA12A7; Mon, 17 Dec 2012 17:35:27 +0100 (CET) Date: Mon, 17 Dec 2012 17:35:27 +0100 (CET) From: Baptiste LHOSTE To: Guillaume Lelarge Cc: pgsql-admin@postgresql.org Message-ID: <1649427356.1769187.1355762127487.JavaMail.root@alaloop.com> In-Reply-To: <1355761119.1977.16.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 >As I said, because they are still visible to other transactions. Try to >see if you have long-lasting transactions. How can I do that ? I check running query in pg_stat_activity, but there is= no query on that table. 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