Re: Concurrency supported?

At 02:20 25/02/01 +0100, Ingo Luetkebohle wrote:
>Hiya,
>
>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
>wait?

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.

Peter