* Henry Combrinck
apache 1.3.31, mod_perl, mod_php, mod_* etc. Documented mod_perl/otrs setup was followed. Using Postgres 7.4.2.
With Postgresql config: log_statement = true log_duration = true
I see zillions of the following:
SELECT sdt.name, sa.create_by, st.until_time FROM article_sen der_type sdt, article sa, ticket st WHERE st.id = 3604 AND sa.ticket_id = st.id AND sdt.id = sa.article_sender_type_id ORDER BY sa.create_time LOG: duration: 533.672 ms - 800ms
This might not solve all your issues, but I'd suggest changing the types of the serial number columns so that your indexes actually come into play. You might want to ask postgres to explain its plan for the query above to confirm that this is a problem for you ("EXPLAIN SELECT sdt.name..."), but I'll bet it is. Se also the thread http://thread.gmane.org/gmane.comp.otrs.devel/530, where Robert Mathews outlines a way to change the type of these columns in-place. (He does this to harmonize the columns to bigint; I'd suggest going from bigint to conventional int.) Arne.