Re: question

On 10/6/2014 10:07 AM, Emi Lu wrote:
> Hello List,
>
> May I know will <idle> cause any potential performance issues for
> psql8.3 please?
> version (PostgreSQL 8.3.18 on x86_64-unknown-linux-gnu, compiled by GCC
> 4.1.2)
>
> E.g., got 10 idle connections for 10 days.
>   select current_query from pg_stat_activity  where usename ='test';
> current_query
> --------------------------------------------------------------------------
>   <IDLE>
>   <IDLE>
>   <IDLE>
>   <IDLE>
>   <IDLE>
>   <IDLE>
>   <IDLE>
>   <IDLE>
>   <IDLE>
>   <IDLE>
>
> Thanks a lot!
> Emi


idle is ok.  It wastes a little extra ram, but wont hurt anything.
"idle in transaction" for long periods of time is bad.

-Andy