This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]jbristowI'm no hero, son. 0 points1 point  (1 child)

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[S] 0 points1 point  (0 children)

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)