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 7D142D1B4EC for ; Sun, 19 Oct 2003 02:21:49 +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 91261-05 for ; Sat, 18 Oct 2003 23:21:22 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 0AC64D1B4E1 for ; Sat, 18 Oct 2003 23:21:18 -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 h9J2L0uo016214; Sat, 18 Oct 2003 22:21:00 -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> Comments: In-reply-to Seum-Lim Gan message dated "Sat, 18 Oct 2003 20:52:32 -0500" Date: Sat, 18 Oct 2003 22:21:00 -0400 Message-ID: <16213.1066530060@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/492 X-Sequence-Number: 4240 Seum-Lim Gan writes: > Sample verbose analyze: > VACUUM VERBOSE ANALYZE hello_rda_or_key; > INFO: vacuuming "craft.hello_rda_or_key" > INFO: index "hello242_1105" now contains 740813 row versions in 2477 pages So what's the problem? That doesn't seem like a particularly bloated index. You didn't say what datatype the index is on, but making the most optimistic assumptions, index entries must use at least 16 bytes each. You're getting about 300 entries per page, compared to the theoretical limit of 512 ... actually more, since I'm not allowing for upper btree levels in this calculation ... which says to me that the page loading is right around the expected btree loading of 2/3. regards, tom lane