Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6711E9F9FE2 for ; Wed, 17 Jan 2007 13:53:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 98135-03 for ; Wed, 17 Jan 2007 13:52:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx00.pub.collaborativefusion.com (mx00.pub.collaborativefusion.com [206.210.89.199]) by postgresql.org (Postfix) with ESMTP id B34E49FB22C for ; Wed, 17 Jan 2007 13:52:04 -0400 (AST) Received: from vanquish.pgh.priv.collaborativefusion.com (vanquish.pgh.priv.collaborativefusion.com [192.168.2.61]) (SSL: TLSv1/SSLv3,256bits,AES256-SHA) by wingspan with esmtp; Wed, 17 Jan 2007 12:52:03 -0500 id 0005648E.45AE6243.00016B10 Date: Wed, 17 Jan 2007 12:52:03 -0500 From: Bill Moran To: Alvaro Herrera Cc: pgsql-general@postgresql.org Subject: Re: Index bloat of 4x Message-Id: <20070117125203.899f6660.wmoran@collaborativefusion.com> In-Reply-To: <20070117171251.GH26080@alvh.no-ip.org> References: <20070117093223.bcdb302e.wmoran@collaborativefusion.com> <20070117154251.GG26080@alvh.no-ip.org> <20070117113216.a6d72185.wmoran@collaborativefusion.com> <20070117171251.GH26080@alvh.no-ip.org> Organization: Collaborative Fusion X-Mailer: Sylpheed 2.3.0 (GTK+ 2.10.7; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/919 X-Sequence-Number: 107459 In response to Alvaro Herrera : > Bill Moran wrote: > > > The entire database was around 28M prior to the upgrades, etc. Immediately > > after the upgrades, it was ~270M. Following a vacuum full, it dropped to > > 165M. Following a database-wide reindex, it dropped to 30M. > > Oh, so it was clearly the upgrade procedure that caused the bloat ... > Reindexing seems the expected course. Right. Sorry if I didn't explain that properly. It wasn't the fact that it bloated that surprised me. It was the _magnitude_ of bloat that I wasn't expecting, as well as the fact that it was _all_ _index_ bloat. -- Bill Moran Collaborative Fusion Inc.