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_t344_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 previous 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 --------- 2584398 (1 row) Can someone give me a clue ? Best regards, Baptiste. --- Baptiste LHOSTE blhoste@xxxxxxxxxxx ALALOOP S.A.S. - Technopole Izarbel - 64210 Bidart Téléphone : +33 (0) 5 59 41 51 10 www.alaloop.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
