Thread: issue?
<small>Hello List, <br /><br /> May I know will <idle> cause any potential performance issues for psql8.3 please?<br/> version (PostgreSQL 8.3.18 on x86_64-unknown-linux-gnu, compiled by GCC 4.1.2)<br /><br /> E.g., got 10 idleconnections for 10 days. <br /> select current_query from pg_stat_activity where usename ='test';<br /> current_query <br /> --------------------------------------------------------------------------<br/> <IDLE><br /> <IDLE><br /> <IDLE><br/> <IDLE><br /> <IDLE><br /> <IDLE><br /> <IDLE><br /> <IDLE><br /> <IDLE><br/> <IDLE><br /><br /> Thanks a lot!<br /> Emi</small><br />
2014-10-06 11:54 GMT-03:00 Emi Lu <emilu@encs.concordia.ca>:
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
Hi Emi,
As far as I know, it wont affect your performance.
It will affect the overall quantity of users that can connect to the database though (since there is a limit that you can set up on postgres.conf).
BR,
Felipe
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.