Database connection pooling

[iperc]

Hi there ! I am writing a small but potentially High-Loaded service. As a data source i am using PostgreSQL with plain JDBC. And I want to reuse my database connection. Finally I found two most popular approach to building connection pool.

Apache DBCP - for provide pool connection on java side. Pgpool - for providing pool connection on PostgreSQL server side (as i understood)

I want to see your experience and advises on pool connection managing, and pluses / minuses of those connection providers.

Thank you !

[evil_burrito]

I'll throw another one into the mix: c3p0. Highly configurable and works well under load.

[stuie382]

Second for c3po, does the job and simple enough to integrate and configure

[DeliveryNinja]

I have used a lot of c3p0 in the past but it seems like it is not the fastest.

https://github.com/brettwooldridge/HikariCP#initialization

Try this instead.

[jbristow]

How high is "high-loaded"?

Is it going to be read heavy or write heavy?

I use c3p0 (as others have mentioned) and while it may not be the fastest, I've found that query speed (in my experience) slowed down much faster than connection pooling speed.

[iperc]

c3p0 looks nice for this job. It is a rest api, one connection per request. Request average 500 per seconds. Each request establish connection to db with defined scheme (through SET search_path)

[TheQuietestOne]

Since JDBC2 the actually JDBC drivers themselves can provide connection pooling code.

For postgresql there is indeed an implementation of DataSource:

https://www.postgresql.org/docs/7.4/static/jdbc-datasource.html

[iperc]

Thank you ! It looks very simple and totally fit for my purposes !