"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> "Aaron Burnett" <aburnett(at)bzzagent(dot)com> wrote:
>> Postgres Version 8.25
>
> Do you mean 8.2.5? (There is no PostgreSQL version 8.25.)
I just noticed that there's an 8.0.25 -- if that's what you're
running, it's a bit silly trying to optimize individual slow queries
-- performance has improved dramatically since then. Upgrade and
see if you still have any issues, and tune from there.
By the way, 8.0 is going out of support as soon as the 9.0 release
comes out; likely next month.
-Kevin