Re: issue?

Поиск
Список
Период
Сортировка
От Felipe Santos
Тема Re: issue?
Дата
Msg-id CAPYcRiWGAsQwHnx1Cse3eLavuAFY2RzAy0pZRdFrqV6vcFc9SA@mail.gmail.com
обсуждение исходный текст
Ответ на issue?  (Emi Lu <emilu@encs.concordia.ca>)
Список pgsql-performance
Дерево обсуждения
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


В списке pgsql-performance по дате отправления: