Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 032A29FB262
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 17 Jan 2007 12:28:17 -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 94022-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 17 Jan 2007 12:28:02 -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 97A349FB22F
	for <pgsql-performance@postgresql.org>;
	Wed, 17 Jan 2007 12:28:02 -0400 (AST)
Received: from out1.internal (unknown [10.202.2.149])
	by out1.messagingengine.com (Postfix) with ESMTP id 15CC57FDBF;
	Wed, 17 Jan 2007 11:28:02 -0500 (EST)
Received: from web2.messagingengine.com ([10.202.2.211])
	by out1.internal (MEProxy); Wed, 17 Jan 2007 11:28:02 -0500
Received: by web2.messagingengine.com (Postfix, from userid 99)
	id D08331F10E; Wed, 17 Jan 2007 11:28:01 -0500 (EST)
Message-Id: <1169051281.3778.1169737659@webmail.messagingengine.com>
X-Sasl-Enc: jcmIFeyRgd0HO3SkVdmJGhz6vTcs+MXzcsIzL7pY7GOl 1169051281
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>
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
In-Reply-To: <1169050746.9586.44.camel@state.g2switchworks.com>
Date: Wed, 17 Jan 2007 11:28:01 -0500
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/261
X-Sequence-Number: 22862

> That's about 32% dead rows.  Might be worth scheduling a vacuum full,
> but it's not like I was afraid it might be.  It looks to me like you
> could probably use a faster I/O subsystem in that machine though.

I'll try to schedule a full vacuum tonight.  As far as I/O - it's using
SAN over fiber.  Not as fast as internal SCSI though...