El lun, 06-10-2014 a las 10:54 -0400, Emi Lu escribió: > 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 Maybe your application is using a pool of 10 connections but it doesn't affect any potential performance issues. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
