Re: Backend message type 0x50 arrived while idle

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
>
>

In response to

Browse pgsql-general by date

  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