Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id C34089FB2AC
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 17 Jan 2007 14:55:32 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024)
	with ESMTP id 89249-07-2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 17 Jan 2007 14:55:06 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from out4.smtp.messagingengine.com (out4.smtp.messagingengine.com
	[66.111.4.28]) by postgresql.org (Postfix) with ESMTP id EF83C9FB2CD
	for <pgsql-performance@postgresql.org>;
	Wed, 17 Jan 2007 14:55:07 -0400 (AST)
Received: from out1.internal (unknown [10.202.2.149])
	by out1.messagingengine.com (Postfix) with ESMTP id 556A07F96E;
	Wed, 17 Jan 2007 13:55:07 -0500 (EST)
Received: from web2.messagingengine.com ([10.202.2.211])
	by out1.internal (MEProxy); Wed, 17 Jan 2007 13:55:07 -0500
Received: by web2.messagingengine.com (Postfix, from userid 99)
	id 3D7619249; Wed, 17 Jan 2007 13:55:07 -0500 (EST)
Message-Id: <1169060107.24972.1169765759@webmail.messagingengine.com>
X-Sasl-Enc: 6Fy8dEdw2lMMJy9f6WwzGcJG+J9MQbkkltfu0VWjmNHU 1169060107
From: "Jeremy Haile" <jhaile@fastmail.fm>
To: "Scott Marlowe" <smarlowe@g2switchworks.com>
Cc: "Chad Wagner" <chad.wagner@gmail.com>, "Tom Lane" <tgl@sss.pgh.pa.us>,
	pgsql-performance@postgresql.org
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="ISO-8859-1"
MIME-Version: 1.0
X-Mailer: MessagingEngine.com Webmail Interface
References: <1168982580.8275.1169588211@webmail.messagingengine.com>
	<26412.1168983547@sss.pgh.pa.us>
	<1168986053.16393.1169598917@webmail.messagingengine.com>
	<81961ff50701161444l3f932755m5a6e15ad2d948130@mail.gmail.com>
	<1169002739.19758.1169636285@webmail.messagingengine.com>
	<1169012767.6271.7.camel@localhost.localdomain>
	<1169044649.19974.1169715743@webmail.messagingengine.com>
	<1169050746.9586.44.camel@state.g2switchworks.com>
	<1169051281.3778.1169737659@webmail.messagingengine.com>
	<1169058911.9586.46.camel@state.g2switchworks.com>
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
In-Reply-To: <1169058911.9586.46.camel@state.g2switchworks.com>
Date: Wed, 17 Jan 2007 13:55:07 -0500
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/270
X-Sequence-Number: 22871

> Also, look at the thread going by about index bloat by 4x.  You'll
> likely want to reindex after a vacuum full since vacuum full doesn't
> reclaim space in indexes and in fact often bloats indexes.

Thanks for the pointer.  That thread might indeed apply to my situation.
 I'm going to reindex the the table tonight.

Jeremy Haile