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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
