We have a web application for Postgre database. During the testing we used org.apache.commons.dbcp.BasicDataSource. Now we need moving to production and we should change this basic datasource with some other one. For Oracle we use oracle.ucp.jdbc.PoolDataSourceFactory.
What is the best datasource for Postgre, considering that our application has approximately 500 users? Should it be enough if we use c3p0 ComboPooledDataSource datasource?
Thank you in advance,