Mahout, PostgreSQL and connection pool

Question

Using PostgreSQL as data source in Mahout 0.9, I keep getting

WARN org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel - You are not using ConnectionPoolDataSource. Make sure your DataSource pools connections to the database itself, or database performance will be severely reduced.

warning.

And it's true - each request keeps opening new connections.

Is there any way to use PGConnectionPoolDataSource for PostgreSQLBooleanPrefJDBCDataModel?

(currently I have no constructorfor arguments n Java::OrgApacheMahoutCfTasteImplModelJdbc::PostgreSQLBooleanPrefJDBCDataModel error)

score 2 · Accepted Answer · answered Oct 29 '14 at 11:10

2

In fact, you'll likely don't need a connections pool at all, as the right solution is to use memory-based ReloadFromJDBCDataModel wrapper, which, as the side-effect, decreases the number of connections to 1.

answered Oct 29 '14 at 11:10

There Are Four Lights

1,406
3
19
35

Mahout, PostgreSQL and connection pool

1 Answers1