>>> Aaron Guyon <battlemage(at)gmail(dot)com> wrote:
> 8.3.3: 1195 ms
> 8.2.12: 611 ms
Could you send the non-commented lines from the postgresql.conf files
from both installations?
If feasible, update to the latest bug-fix version of 8.3.
Also, if you haven't already done so, try setting effective_cache_size
= '3GB' and random_page_cost = 2 for the 8.3 database and restart to
see what kind of plan you get.
-Kevin