activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lachezar Dobrev <l.dob...@gmail.com>
Subject Re: Persistent messages and postgres backend
Date Mon, 24 Oct 2016 09:41:34 GMT
  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.Herbst@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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message