Yeah, I vacuumed it. One thing on openacs.org is that I changed acs__magic_object_id to be with(iscachable).
Making the same change on my side gives something that is
still pretty horrible:
Nested Loop (cost=11105.20..14252.40 rows=1 width=1482)
-> Index Scan using forums_messages_pk on forums_messages f (cost=0.00..3.02 rows=1 width=983)
-> Materialize (cost=13829.18..13829.18 rows=33616 width=499)
-> Hash Join (cost=11105.20..13829.18 rows=33616 width=499)
-> Merge Join (cost=0.00..2494.57 rows=33621 width=354)
-> Index Scan using parties_pk on parties pa (cost=0.00..812.76 rows=33637 width=146)
-> Index Scan using users_pk on users u (cost=0.00..1093.40 rows=33621 width=208)
-> Hash (cost=11021.16..11021.16 rows=33616 width=145)
-> Hash Join (cost=2448.11..11021.16 rows=33616 width=145)
-> Hash Join (cost=1812.82..9713.52 rows=33621 width=129)
-> Hash Join (cost=1055.56..8642.72 rows=33628 width=99)
-> Seq Scan on acs_objects o (cost=0.00..6014.54 rows=230454 width=91)
-> Hash (cost=971.49..971.49 rows=33628 width=8)
-> Seq Scan on group_element_index (cost=0.00..971.49 rows=33628 width=8)
-> Hash (cost=673.21..673.21 rows=33621 width=30)
-> Seq Scan on persons pe (cost=0.00..673.21 rows=33621 width=30)
-> Hash (cost=551.23..551.23 rows=33623 width=16)
-> Seq Scan on membership_rels mr (cost=0.00..551.23 rows=33623 width=16)
I have not committed the acs__magic_object with(iscachable) since I am scared it will break something (oh, and isstrict
should be there as well I think). Should I commit it?