[PERFORM] Poor query plan chosen in 9.0.3 vs 8.3.7

2011-05-05 Thread Brian Connolly
on objectproperty (cost=0.00..3.31 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=67044) Index Cond: ((objectid = $1) AND (propertyid = 1288)) Total runtime: 194080.893 ms Thank you, Brian Connolly

Re: [PERFORM] Poor query plan chosen in 9.0.3 vs 8.3.7

2011-05-05 Thread Brian Connolly
- autovacuum = on - All other settings default - Vacuum and Analyze is run nightly. Thank you for any help you might be able to provide. Brian Connolly