Search Postgresql Archives

Is it normal to have too many idle processes in postgresql cluster?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all, I have a database cluster running Postgresql 9.6 on RHEL 6 servers. I've noticed a lot of idle processes in the master database as opposed to the slave database and from the looks of pg_activity, they're all idle statements like "SELECT 1". Forums and StackOverflow seems to suggest its nothing to worry about but 

[user@xxxxxx ~]$ ps -ef | grep postgres | grep idle | wc -l
213  

Seems to get me worried. Should I be worried? Is this normal? If not, what should I do?
--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux