Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tkd4W-0003NZ-Vb for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 15:57:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tkd4W-0002Dp-GU for pgsql-admin@arkaria.postgresql.org; Mon, 17 Dec 2012 15:57:40 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tkd4V-0002Dj-PO for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 15:57:39 +0000 Received: from mx0.network-studio.com ([62.93.225.99]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tkd4U-0000Tx-5q for pgsql-admin@postgresql.org; Mon, 17 Dec 2012 15:57:38 +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 553D8408115 for ; Mon, 17 Dec 2012 16:57:36 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by zimbra-ne01.network-studio.com (Postfix) with ESMTP id 51D30DA1FCF for ; Mon, 17 Dec 2012 16:57:36 +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 SCdDu4hn2EzZ for ; Mon, 17 Dec 2012 16:57:35 +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 E1108DA1F94 for ; Mon, 17 Dec 2012 16:57:35 +0100 (CET) Date: Mon, 17 Dec 2012 16:57:35 +0100 (CET) From: Baptiste LHOSTE To: pgsql-admin@postgresql.org Message-ID: <157467040.1756135.1355759855861.JavaMail.root@alaloop.com> In-Reply-To: <925893418.1753694.1355759486054.JavaMail.root@alaloop.com> Subject: [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 Hi everybody, I have trouble understanding some logs of postgreSQL. Here you can find a log from the auto-vacuum process : 2012-12-17 16:38:58 CET LOG: automatic vacuum of table "flows.public.agg_t= 344_outgoing_a41_src_net_and_dst_net_f5": index scans: 0 pages: 0 removed, 59820 remain tuples: 0 removed, 5801752 remain system usage: CPU 0.93s/0.95u sec elapsed 423.07 sec I am right to conclude that there is 5801752 available tuples in the previo= us table ? If true, I am very confused because our table can not exceed 2592000 tuples= (We delete old ones). To be sure I tried to run the following query to count availables tuples : select count(*) from agg_t344_outgoing_a41_src_net_and_dst_net_f5; count=20=20 --------- 2584398 (1 row) Can someone give me a clue ? 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