You might want to add an INDEX on CONTAINER column in ACTIVEMQ_MSGS table: CREATE INDEX ACTIVEMQ_MSGS_CONTAINER_INDEX ON ACTIVEMQ_MSGS(CONTAINER);
2016-10-24 12:14 GMT+03:00 <ulrich.her...@t-systems.com>: > 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 > >