Hi all, we need persistent messages with a postgres backend.
We did some performance tests... and with about 70.000 Rows in ACTIVEMQ_MSGS we saw postgres log entries with: duration: 15439.610 ms execute <unnamed>: SELECT ID, MSG FROM ACTIVEMQ_MSGS WHERE CONTAINER=$1 ORDER BY ID DETAIL: parameters: $1 = 'topic://Test.Foo2' That is: Postgres sees queries with 15 (and more) seconds responsetime. Ok, we see - our ActiveMQ is slow. Any ideas how to tune ActiveMQ and/or Postgres database here ? Uli
