From: | Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com> |
---|---|
To: | Doug McNaught <doug(at)mcnaught(dot)org> |
Cc: | "Wynn, Robin" <RWynn(at)northropgrumman(dot)com>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Backend message type 0x50 arrived while idle |
Date: | 2002-12-04 19:40:22 |
Message-ID: | 3DEE5A26.6090007@intransa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Doug McNaught wrote:
>"Wynn, Robin" <RWynn(at)northropgrumman(dot)com> writes:
>
>
>
>AFAIK it's extremely bad practice in general to share a connection
>between two threads, unless you protect it with some kind of lock to
>avoid simultaneous use. Using a connection per thread is a much
>better idea. The only issue with that is that one thread won't see
>results of an in-progress transaction until the other thread commits.
>
>
I agree with you on seperate connections, and as for the multiple
threads seeing
the latest values of data or data sets, ... no new problem has been
added, its just
that now the source of the data object(s) are a TCP connectiion away,
instead of a
RAM memory controller (or mem manager) away....
>-Doug
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Nasser | 2002-12-04 19:42:44 | Re: UTF encoding error |
Previous Message | Fernando Nasser | 2002-12-04 19:37:55 | Re: JDBC driver - first impressions and comments |