Re: backend pid changing - Mailing list pgsql-performance

From Lewis Kapell
Subject Re: backend pid changing
Date
Msg-id 4846B244.7020307@setonhome.org
Whole thread Raw
In response to Re: backend pid changing  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses PgPool parallel query performance rules of thumb
List pgsql-performance
We are not using connection pooling, however the clients are tunneling
through SSH.  Forgot to mention that in my first message.  Does that
make any difference to it?

Thank you,

Lewis Kapell
Computer Operations
Seton Home Study School


Tom Lane wrote:
> Lewis Kapell <lkapell@setonhome.org> writes:
>> ... By examining the logs, I have observed that the
>> backend pid for a particular client sometimes changes during a session.
>
> That is just about impossible to believe, unless perhaps you have a
> connection pooler in the loop somewhere?
>
>             regards, tom lane

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: insert/update tps slow with indices on table > 1M rows
Next
From: John Beaver
Date:
Subject: PgPool parallel query performance rules of thumb