Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 473FC632D51
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  9 Nov 2009 11:49:46 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 69474-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  9 Nov 2009 15:49:37 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-yx0-f181.google.com (mail-yx0-f181.google.com
	[209.85.210.181])
	by mail.postgresql.org (Postfix) with ESMTP id 4CC1F632CEC
	for <pgsql-performance@postgresql.org>;
	Mon,  9 Nov 2009 11:49:38 -0400 (AST)
Received: by yxe11 with SMTP id 11so2551318yxe.15
	for <pgsql-performance@postgresql.org>;
	Mon, 09 Nov 2009 07:49:36 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=0KOHTsApXS2matOjdUiD6Ls5FAqn+DSWPfJas3JUkxA=;
	b=dQ9xEgQMST9zFktQUyi8mo6caIaRv1fLWUfRPq9f8HMNyGDhI3sY8jmCVhmM7l7shb
	hQI5sv3GzyOQWyxQ3okICahamrscp/peAmrbLBWIv7uyRhdyQZeNcOXgjaD2N0igBnPv
	fRiHhGW+yDcIxYIklw7qIphU1EouexSjJNnU8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=eSDudiK3RgCkYuG/xyEd/UyAFKH+ttynDKjQmbzyfJ0XkG2ZtQcb6+dbi/OgAmw29O
	bjZ6I4l6H0+wpPwkKr1H9fCOTgHTFbm4yr2CEb7LINuhsfc2XinJml/TVHs0jZueqLkS
	bkuxx7xnhtLvfqTUUg+wl0CLc3/3C532DyOWI=
MIME-Version: 1.0
Received: by 10.239.138.12 with SMTP id n12mr787100hbn.69.1257781775591; Mon,
	09 Nov 2009 07:49:35 -0800 (PST)
In-Reply-To: <f2fd819a0911090646w159e6e4bu309742528554068f@mail.gmail.com>
References: <008801ca6021$c1cc7630$45656290$@com>
	<18869.1257650960@sss.pgh.pa.us> <009601ca6030$0e731440$2b593cc0$@com>
	<603c8f070911081958sbac9712k15f50b80e5419d3c@mail.gmail.com>
	<f2fd819a0911090646w159e6e4bu309742528554068f@mail.gmail.com>
Date: Mon, 9 Nov 2009 10:49:35 -0500
Message-ID: <603c8f070911090749k541b4c3nc4888f54b28f93fe@mail.gmail.com>
Subject: Re: CREATE TABLE slowing down significantly over time
From: Robert Haas <robertmhaas@gmail.com>
To: Anj Adu <fotographs@gmail.com>
Cc: Aris Samad-Yahaya <aris@quickschools.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200911/93
X-Sequence-Number: 36261

On Mon, Nov 9, 2009 at 9:46 AM, Anj Adu <fotographs@gmail.com> wrote:
> Why is reindex needed ?

VACUUM FULL does not fix index bloat, only table boat.

...Robert