pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Help with connections
2+ messages / 1 participants
[nested] [flat]

* Help with connections
@ 2005-05-12 15:25 Gourish Singbal <gourish@gmail.com>
  2005-05-13 13:21 ` Re: Help with connections Gourish Singbal <gourish@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Gourish Singbal @ 2005-05-12 15:25 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Help with connections
  2005-05-12 15:25 Help with connections Gourish Singbal <gourish@gmail.com>
@ 2005-05-13 13:21 ` Gourish Singbal <gourish@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Gourish Singbal @ 2005-05-13 13:21 UTC (permalink / raw)
  To: pgsql-admin

Found the problem.
The Application opens the connections retrives the result set and does
processing on the data based on certian logic and than closes the
connections.
But during the time  application does processing the connections are
open . thats the time i see 53 idle connections.

regards
Gourish


On 5/12/05, Gourish Singbal <gourish@gmail.com> wrote:
> 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
> 


-- 
Best,
Gourish Singbal



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-05-13 13:21 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-12 15:25 Help with connections Gourish Singbal <gourish@gmail.com>
2005-05-13 13:21 ` Gourish Singbal <gourish@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox