X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3EECC52875 for ; Tue, 14 Jun 2005 10:36:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60067-06 for ; Tue, 14 Jun 2005 13:36:21 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 005875293A for ; Tue, 14 Jun 2005 10:36:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j5EDZ4AU027819; Tue, 14 Jun 2005 09:35:05 -0400 (EDT) To: Tsirkin Evgeny Cc: pgsql-admin@postgresql.org Subject: Re: reading vacuum verbose output In-reply-to: <42AEA3F2.4000202@mail.jct.ac.il> References: <42AEA3F2.4000202@mail.jct.ac.il> Comments: In-reply-to Tsirkin Evgeny message dated "Tue, 14 Jun 2005 12:31:30 +0300" Date: Tue, 14 Jun 2005 09:35:04 -0400 Message-ID: <27818.1118756104@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/89 X-Sequence-Number: 17844 Tsirkin Evgeny writes: > INFO: --Relation public.student2maslulsign_rashum_musmach_old-- > INFO: Pages 906: Changed 0, Empty 0; Tup 846: Vac 0, Keep 0, UnUsed 96035. > Total CPU 0.03s/0.01u sec elapsed 0.04 sec. > If there are unused tuples why i see the Changed 0 ? Those are unused tuple slots, not tuples. They can be re-used, but they won't be reclaimed unless the page they are in is truncated from the table. > (Note :The db is vacuumed every ~5 hours ver 7.3) It would appear that you need a round of VACUUM FULL to get these tables back down to a reasonable physical size, and in future vacuum more often. Check your FSM settings too. regards, tom lane