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 E0766D1B4E3 for ; Sat, 18 Oct 2003 21:53:50 +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 54497-06 for ; Sat, 18 Oct 2003 18:53:22 -0300 (ADT) Received: from slgan.com (c-67-163-28-202.client.comcast.net [67.163.28.202]) by svr1.postgresql.org (Postfix) with ESMTP id 401D3D1B4E6 for ; Sat, 18 Oct 2003 18:53:19 -0300 (ADT) Received: from [192.168.10.52] ([192.168.10.52]) by slgan.com (8.10.2/8.10.2) with ESMTP id h9ILtqr19511 for ; Sat, 18 Oct 2003 16:55:52 -0500 Mime-Version: 1.0 X-Sender: slgan@192.168.10.10 Message-Id: Date: Sat, 18 Oct 2003 16:55:14 -0500 To: pgsql-performance@postgresql.org From: Seum-Lim Gan Subject: index file bloating still in 7.4 ? Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/489 X-Sequence-Number: 4237 Hi, I downloaded PostgreSQL 7.4beta4 and tried it out. It turns out that the index file is still bloating even after running vacuum or vacuum analyze on the table. Still, only reindex will claim the space back. Is the index bloating issue still not resolved in 7.4beta4 ? Thanks. Gan -- +--------------------------------------------------------+ | Seum-Lim GAN email : slgan@lucent.com | | Lucent Technologies | | 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 | | Naperville, IL 60566, USA. fax : (630)-713-7272 | | web : http://inuweb.ih.lucent.com/~slgan | +--------------------------------------------------------+