On Thu, Mar 5, 2009 at 1:57 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: >>>> 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. I still there's a problem with that index, now it's called idx_payment_amount_payment_id. What do you get from this? select * from pg_index where indexrelid = 'idx_payment_amount_payment_id'::regclass; Have you tried: reindex table payment_amount ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
