Hi DJ, I will dig into this deeper next week together with our DB guru. Your hint about indices ...
backup db drop database install -dis backup db restore only data from first backup ... there are quite a few foreign key constraint error messages and the tables / indices are not the same as before. The database is quite "old", having seen several OpenNMS version from about 1.5.90. Somewhere during the different upgrades there must have been problems creating new indices. I will write you as soon as I know more, maybe this is an issue of the upgrade process. For the prepared statements: http://www.postgresql.org/docs/current/static/sql-prepare.html "Prepared statements only last for the duration of the current database session. When the session ends, the prepared statement is forgotten, so it must be recreated before being used again. This also means that a single prepared statement cannot be used by multiple simultaneous database clients; however, each client can create their own prepared statement to use." So the prepare is kept by postgres for the running session. First results from further tracking down is that the prepares takes about only 20%-35% of all the queries of the two sql statements I sent last time, so probably it could be improved but probably is not the source of our performance issues. -Michael Ihr starker Gesundheitspartner – die neue BARMER GEK. Gemeinsam. Noch besser! www.barmer-gek.de Diese Nachricht der BARMER GEK kann vertrauliche firmeninterne Informationen enthalten. Sofern Sie nicht der beabsichtigte Empfänger sind, bitten wir Sie, den Absender zu informieren und die Nachricht sowie deren Anhänge zu löschen. Unzulässige Veröffentlichung, Verwendung, Verbreitung, Weiterleitung und das Kopieren dieser Mail und ihrer verknüpften Anhänge sind nicht gestattet. ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-devel mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-devel
