2014-10-06 11:54 GMT-03:00 Emi Lu <em...@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
