X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D7234DB411 for ; Mon, 31 Oct 2005 17:23:01 -0400 (AST) 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 43919-02 for ; Mon, 31 Oct 2005 21:22:59 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 92499DB479 for ; Mon, 31 Oct 2005 17:23:00 -0400 (AST) 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 j9VLMxda019098; Mon, 31 Oct 2005 16:23:00 -0500 (EST) To: "Subbiah, Stalin" Cc: pgsql-admin@postgresql.org Subject: Re: Vacuum Verbose output In-reply-to: <6B26A56846293C4488B54CF3E440335403E2F77A@mxca2.corp.netopia.com> References: <6B26A56846293C4488B54CF3E440335403E2F77A@mxca2.corp.netopia.com> Comments: In-reply-to "Subbiah, Stalin" message dated "Mon, 31 Oct 2005 12:13:27 -0800" Date: Mon, 31 Oct 2005 16:22:59 -0500 Message-ID: <19097.1130793779@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.006 required=5 tests=[AWL=0.006] X-Spam-Score: 0.006 X-Spam-Level: X-Archive-Number: 200510/295 X-Sequence-Number: 19367 "Subbiah, Stalin" writes: > INFO: vacuuming "public.eventlog" > INFO: index "ix_eventlog_eventtime" now contains 11465395 row versions > in 77113 pages > DETAIL: 8737797 index row versions were removed. > Does it mean ix_eventlog_ index had 11.4mil row versions out of which > 8.7mil were removed cause of deletes? No, it says "now contains", ie those are the post-removal statistics. > 33189 index pages have been deleted, 0 are currently reusable. > Does it mean out of 77113 index pages, 33189 were deleted? Yeah --- so almost half the space in the index is free space (more than half according to the later report). Possibly you should be vacuuming this table a bit more often... > Why does index and table INFO reported twice with different row version > numbers on a vacuum run. Because it had to do two passes of row removal, due to not having enough vacuum_mem to remember all the dead rows at once. regards, tom lane