Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 1656F9FB2C1
	for <pgsql-general-postgresql.org@postgresql.org>;
	Fri, 19 Jan 2007 13:45:27 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 78056-10 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Fri, 19 Jan 2007 13:45:10 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id AAC129FB252
	for <pgsql-general@postgresql.org>;
	Fri, 19 Jan 2007 13:45:10 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l0JHj3Wa017159;
	Fri, 19 Jan 2007 12:45:03 -0500 (EST)
To: "Ed L." <pgsql@bluepolka.net>
cc: Csaba Nagy <nagy@ecircle-ag.com>,
	Postgres general mailing list <pgsql-general@postgresql.org>,
	Bill Moran <wmoran@collaborativefusion.com>,
	Alvaro Herrera <alvherre@commandprompt.com>
Subject: Re: Index bloat of 4x 
In-reply-to: <200701191019.52768.pgsql@bluepolka.net> 
References: <20070117093223.bcdb302e.wmoran@collaborativefusion.com>
	<200701181842.00696.pgsql@bluepolka.net>
	<1169197877.11526.10.camel@coppola.muc.ecircle.de>
	<200701191019.52768.pgsql@bluepolka.net>
Comments: In-reply-to "Ed L." <pgsql@bluepolka.net>
	message dated "Fri, 19 Jan 2007 10:19:52 -0700"
Date: Fri, 19 Jan 2007 12:45:03 -0500
Message-ID: <17158.1169228703@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/1075
X-Sequence-Number: 107615

"Ed L." <pgsql@bluepolka.net> writes:
> Online index creation definitely helps us toward 24x7.  But 
> wouldn't we still have to drop the old index, thus blocking 
> production queries?

Yes, but only for a very short period.

			regards, tom lane