DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=qdIoyqLNJR0asLeAbncTe1uxAThfUx6Gk2Z/8BBCLGS0TP6K+mVWZHwT6DWqkGjA/GNdc6lQt1vyrkLC2JGSgyT4XSNS0iwEjIV7jfjwYUgBHvFx2gy4xWJTfDOdlYIM5M9bNi3xkOL+VxCc+dEVT90wbWmSnn34g4TonCRUJ+8=
Message-ID: <e7f9235d0805261709k638dbb23jef43b8fe62861fc7@mail.gmail.com>
Date: Mon, 26 May 2008 20:09:30 -0400
From: "David Wilson" <david.t.wilson@gmail.com>
To: Justin <justin@emproshunts.com>
Subject: Re: select query takes 13 seconds to run with index
Cc: mark <markkicks@gmail.com>, pgsql-general@postgresql.org
In-Reply-To: <483B4729.7050402@emproshunts.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <82fa9e310805261549m2362fbe8sbf18789938fee833@mail.gmail.com>
	<483B4729.7050402@emproshunts.com>

On Mon, May 26, 2008 at 7:26 PM, Justin <justin@emproshunts.com> wrote:
> The estimate is way off, when was the last time Vaccum was on the table?

I'm going to second this- run "ANALYZE pokes;" and then test the query
again; I'll bet you'll get much better results.

It's not the VACUUM that matters so much as the ANALYZE, and it
definitely needs to be done on occasion if you're adding a lot of
records. Do you have the autovacuum daemon running? (And if not, why
not?)


-- 
- David T. Wilson
david.t.wilson@gmail.com