Apache ActiveMQ 5.15.12 performance improvement on JDBC persistence adapter
Some weeks ago, I identified a performance issue on ActiveMQ (affecting up to 5.15.11 release) when using PostgreSQL as JDBC persistence adapter. For instance, JDBC persistence adapter is an alternative to KahaBD and configured in activemq.xml as follow: <broker ...> ... <persistenceAdapter> <jdbcPersistenceAdapter dataSource="#postgres-ds"/> </persistenceAdapter> ... </broker> ... <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource"> <property name="url" value="jdbc:postgresql://192.168.99.100:5432/activemq"/> <property name="user" value="activemq"/> <property name="password" value="activemq"/> <property name="initialConnections" value="1"/> <property name="maxConnections" value="10"/> </bean> ... The problem occurs when we have lot of pending message