Measurement tool for POSTGRES

Поиск
Список
Период
Сортировка
От Andras Balogh
Тема Measurement tool for POSTGRES
Дата
Msg-id 00dd01bfaa9d$355789e0$0200a8c0@grafx.ro
обсуждение исходный текст
Список pgsql-general
            Hi everyone,
 
    This is my first post to the list so excuse me if the question is not appropriate
for this list.
    I am connecting to the postgres database trough JDBC from servlets. Everything is
working OK but sometimes the system crashes due to heavy load. Our server is hosting a
lot of websites and some of them are doing extensive database querying.
    I am looking for a tool that shows how many open connections are in postgres. Also is it possible
to set how many open connection can be ? In a few servlets we are not closing the connection  
for a very long time to have faster database access.
 
Any help is appreciated.
 
 
Thank You,
 
                    Andras. 
 
 
  
 
 
 
       
 
 

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

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Repairing stuff when broken.
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: OID rollover?