YEs, on Pg72 I did the export:
pg_dump -O -d -R -D -Fp -x -c -f myDB.Jan04.sql myDB
and imported the text sql with psql.
I have 5.5 million rows for this view
acs_object_grantee_priv_map := SELECT a.object_id,
a.grantee_id, m.descendant AS privilege FROM
acs_permissions_all a, acs_privilege_descendant_map m
WHERE (a.privilege = m.privilege);
which is nested in view
acs_object_party_privilege_map
which is joined with users and specifically user 'admin' on
startup, see above.
That's where it hangs...
Further analysis in Postgres showed, that
the indexes are there. The only difference btw. old and new
system - that I can think of - is the nspostgres.so driver
on AolServer 4.1 vs. the old postgres.so on 3.4 and that the
new system has database and AolServer distributed vs. a
colocated setup previously.
What is also strange is that the query as seen in the ns_log
output above executes in < 1s from AolServer at startup, but
when connecting to PG with psql, it takes >15 mins. before I
kill it. I.e. I cannot run it manually on old OR new system.
Has anyone an explanation for that?