- wal_buffers = 4MB
- checkpoint_segments = 10
- checkpoint_timeout = 15min
- random_page_cost = 1.5 and 4.0 (tested with both default and
non-default)
- effective_cache_size = 6144MB
- join_collapse_limit = 10
- 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
jecturi)::text)
SubPlan 1
-> Index Scan using pk_objectproperty on objectproperty
(cost=0.00..3.31 rows=1 width=13) (actual time=0.005..0.007 rows=1
loops=67044)
Index Cond: ((objectid = $0) AND (propertyid = 560))
SubPlan 2
-> Index Scan using pk_objectproperty 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
