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