The old forum calls exactly the same.
Both instances of openacs are on the same machine.
A diff on the file in 2.0.3 and 2.1 returned no differences.
The analysis for the deleted query returned this query plan for the after-upgrade installation:
QUERY PLAN
Merge Join (cost=6700.19..28463.87 rows=1331364 width=180) (actual time=0.27..239.48 rows=16 loops=1)
Merge Cond: ("outer".object_id = "inner".ancestor_id)
-> Index Scan using acs_permissions_pk on acs_permissions p (cost=0.00..4821.55 rows=115414 width=176) (actual time=0.11..173.07 rows=81449 loops=1)
-> Sort (cost=6700.19..6705.96 rows=2307 width=4) (actual time=0.13..0.15 rows=14 loops=1)
Sort Key: acs_object_context_index.ancestor_id
-> Index Scan using acs_object_context_index_pk on acs_object_context_index (cost=0.00..6571.32 rows=2307 width=4) (actual time=0.08..0.10 rows=5 loops=1)
Index Cond: (object_id = 367496)
Total runtime: 239.56 msecThe Time analysis for that query returned this:
time psql unima0 -f test.sql
grantee_id | grantee_name | object_type | read_p | read_checked | create_p | create_checked | write_p | write_checked | admin_p | admin_checked | any_perm_p_
------------+----------------------------+-------------------+--------+--------------+----------+----------------+---------+---------------+---------+---------------+-------------
40727 | Stefan Wurdack | user | 0 | | 0 | | 0 | | -1 | | -1
435 | Main Site Administrators | rel_segment | 0 | | 0 | | 0 | | 0 | | 0
434 | Main Site Members | rel_segment | 0 | | 0 | | 0 | | 0 | | 0
52201 | Registered .LRN Guests | rel_segment | 0 | | 0 | | 0 | | 0 | | 0
52202 | Registered .LRN Non-Guests | rel_segment | 0 | | 0 | | 0 | | 0 | | 0
-1 | The Public | group | -1 | | 0 | | 0 | | 0 | | -1
-2 | Registered Users | application_group | 0 | | 0 | | 0 | | 0 | | 0
(7 rows)real 1m11.734s
user 0m0.002s
sys 0m0.003s
