>>> Aaron Guyon <battlemage@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
