[snip]
> I have only one connection by web session. It is good or bad?
> I have already increased the number of connections to 800 in the
> postgres and sysctl configuration file.
You should probably google for "connection pool" in general to see what
that means, and pick a solution for JDBC. 800 connections is way too
much, we have here ~100 in real use at any time for a busy (read: with
many users and web sessions) application.
Cheers,
Csaba.