Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkeSS-0004mW-Oh for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 17:26:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TkeSR-0007wr-T4 for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 17:26:27 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkeSQ-0007wg-OV for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 17:26:26 +0000 Received: from mx0.network-studio.com ([62.93.225.99]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkeSP-0001o9-CA for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 17:26:25 +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 D3C0540811E; Mon, 17 Dec 2012 18:26:24 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by zimbra-ne01.network-studio.com (Postfix) with ESMTP id CB2EEDA1B54; Mon, 17 Dec 2012 18:26:24 +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 7kpfajwvmTjb; Mon, 17 Dec 2012 18:26:24 +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 75786DA1457; Mon, 17 Dec 2012 18:26:24 +0100 (CET) Date: Mon, 17 Dec 2012 18:26:24 +0100 (CET) From: Baptiste LHOSTE To: Tom Lane Cc: Guillaume Lelarge , pgsql-admin@postgresql.org Message-ID: <592550654.1783675.1355765184399.JavaMail.root@alaloop.com> In-Reply-To: <26830.1355763665@sss.pgh.pa.us> 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 > Does "select * from pg_prepared_xacts" find anything? Yes indeed, so I rollback our old prepared transactions. I will check tomorrow, and I will let you know. 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