Thank you for your answer - we have tried this before with no success. Uli
-----Ursprüngliche Nachricht----- Von: Lachezar Dobrev [mailto:[email protected]] Gesendet: Montag, 24. Oktober 2016 11:42 An: [email protected] Betreff: Re: Persistent messages and postgres backend 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 <[email protected]>: > 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 > >
