On Mon, May 26, 2008 at 7:26 PM, Justin <justin@xxxxxxxxxxxxxxx> 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@xxxxxxxxx
