X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 180BCD1B51E for ; Sun, 19 Oct 2003 05:49:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 19401-03 for ; Sun, 19 Oct 2003 02:48:40 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 19169D1B523 for ; Sun, 19 Oct 2003 02:48:39 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h9J5mTuo017173; Sun, 19 Oct 2003 01:48:29 -0400 (EDT) To: Seum-Lim Gan Cc: josh@agliodbs.com, pgsql-performance@postgresql.org Subject: Re: index file bloating still in 7.4 ? In-reply-to: References: <200310181458.15575.josh@agliodbs.com> <16213.1066530060@sss.pgh.pa.us> Comments: In-reply-to Seum-Lim Gan message dated "Sun, 19 Oct 2003 00:11:13 -0500" Date: Sun, 19 Oct 2003 01:48:29 -0400 Message-ID: <17172.1066542509@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/494 X-Sequence-Number: 4242 Seum-Lim Gan writes: > INFO: vacuuming "craft.dsperf_rda_or_key" > INFO: index "hello242_1105" now contains 1792276 row versions in 6237 pages > DETAIL: 0 index pages have been deleted, 0 are currently reusable. > CPU 0.61s/0.36u sec elapsed 17.92 sec. > INFO: "hello_rda_or_key": found 0 removable, 1791736 nonremovable > row versions in 30892 pages > DETAIL: 1492218 dead row versions cannot be removed yet. You still haven't got an index-bloat problem. I am, however, starting to wonder why you have so many dead-but-unremovable rows. I think you must have some client process that's been holding an open transaction for a long time. regards, tom lane