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 888D95287A for ; Tue, 14 Jun 2005 06:29:09 -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 10079-02 for ; Tue, 14 Jun 2005 09:29:00 +0000 (GMT) Received: from mail2.cc.huji.ac.il (real-outmail.cc.huji.ac.il [132.64.1.18]) by svr1.postgresql.org (Postfix) with ESMTP id 5F5F752885 for ; Tue, 14 Jun 2005 06:28:57 -0300 (ADT) Received: from mail2.cc.huji.ac.il (localhost [127.0.0.1]) by mail2.cc.huji.ac.il (Postfix) with SMTP id 733B01A19B2; Tue, 14 Jun 2005 12:28:49 +0300 (IDT) Received: by mail2.cc.huji.ac.il (Postfix, from userid 31998) id 6476D1A19BF; Tue, 14 Jun 2005 12:28:49 +0300 (IDT) Received: from [132.64.52.127] (evegeni.mm.huji.ac.il [132.64.52.127]) by mail2.cc.huji.ac.il (Postfix) with ESMTP id 1B6B11A19B2 for ; Tue, 14 Jun 2005 12:28:45 +0300 (IDT) Message-ID: <42AEA3F2.4000202@mail.jct.ac.il> Date: Tue, 14 Jun 2005 12:31:30 +0300 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: reading vacuum verbose output Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.761 from Mon Jun 13 17:41:29 2005 CEST X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/88 X-Sequence-Number: 17843 Hello list! I have run a vacuum verbose on a db and got something a can't understand by myself : INFO: Pages 4768: Changed 0, Empty 0; Tup 4764: Vac 0, Keep 0, UnUsed 542404. Total CPU 0.35s/0.00u sec elapsed 1.51 sec. 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. INFO: --Relation public.preconditioncourse-- INFO: Pages 297: Changed 0, Empty 0; Tup 3754: Vac 0, Keep 0, UnUsed 24163. Total CPU 0.01s/0.00u sec elapsed 0.02 sec. INFO: --Relation public.course-- INFO: Pages 40891: Changed 0, Empty 0; Tup 13203: Vac 0, Keep 0, UnUsed 1413836. Total CPU 1.22s/0.17u sec elapsed 2.94 sec. INFO: --Relation public.counter-- INFO: Pages 6050: Changed 0, Empty 0; Tup 10701: Vac 0, Keep 0, UnUsed 690548. Total CPU 0.28s/0.01u sec elapsed 5.91 sec. If there are unused tuples why i see the Changed 0 ? Probably i misunderstand the output fields can somebody please explain those to me? (Note :The db is vacuumed every ~5 hours ver 7.3) Thanks.