Help with connections
От | Gourish Singbal |
---|---|
Тема | Help with connections |
Дата | |
Msg-id | 674d1f8a05051208252c67f6f6@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Help with connections
|
Список | pgsql-admin |
Guys i need some help. Initially the connections to the database were 3 as seen using netstat -a -n | grep "ESTAB" | grep <ip> and ps -ef | grep postgres After some time the connections suddenly incresed to 53 using the above commands. if i do /usr/local/pgsql/bin/psql -d <database> -c "select c.relname,d.datname,transaction,pid,mode,granted from pg_locks l,pg_class c,pg_database d where l.relation=c.oid and l.database=d.oid"; i get only relname | datname | transaction | pid | mode | granted --------------------+----------------+-------------+-------+-----------------+--------- pg_class | rpt_production | | 25903 | AccessShareLock | t pg_locks | rpt_production | | 25903 | AccessShareLock | t pg_class_oid_index | rpt_production | | 25903 | AccessShareLock | t That means there were no tables accessed at this particular time. But why is the connections to database showing 53 ?. The Applicatoin is closing the connections. After about 30 -40 secs the connections drop to 4 or 5 agian. Please advice the max number of conenctions are 100 in the conf file .. how about increasing to 200 ?. -- Best, Gourish Singbal
В списке pgsql-admin по дате отправления: