At 02:20 25/02/01 +0100, Ingo Luetkebohle wrote:
>how good is concurrency supported in the JDBC driver? For example, if
>I have a small process with about 50 threads, some of them requesting
>large objects, will one JDBC connection suffice? If one thread is
>executing a large select which takes seconds to execute, will other
>threads be able to still get their results in time or do they have to

They have to wait as there is only one physical network connection. To get 
round this, you need to use a Connection pool.

>In general, are there concurrency limitations in the protocol
>PostgreSQL uses?

Only 1 action can occur at one time, be it an SQL query or a FastPath 
command. The JDBC driver however ensures that only one Thread has ownership 
of the connection at any one time.


Reply via email to