pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: Fei Liu <fei.liu@aepnetworks.com>
To: pgsql-performance@postgresql.org, Fei Liu <fei.liu@aepnetworks.com>
Subject: large number of connected connections to postgres database (v8.0)
Date: Tue, 17 Jul 2007 14:51:05 -0400
Message-ID: <469D0F99.1030002@aepnetworks.com> (raw )
It appears my multi-thread application (100 connections every 5 seconds)
is stalled when working with postgresql database server. I have limited
number of connections in my connection pool to postgresql to 20. At the
begining, connection is allocated and released from connection pool as
postgres serves data request. The pool can recover from exhaustion. But
very quickly (after about 400 client requests), it seems postgres server
stops serving and connection to postgres server is not released any more
resulting a resource exhausting for clients.
Anyone have experience with the performance aspect of this?
Fei
unix 3 [ ] STREAM CONNECTED 1693655
31976/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693654
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693653
31975/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693652
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693651
31974/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693650
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693649
31973/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693648
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693647
31972/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693646
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693645
31971/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693644
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693641
31969/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693640
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693639
31968/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693638
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693637
31967/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693636
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693585
31941/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693584
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693583
31940/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693582
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693581
31939/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693580
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693579
31938/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693578
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693577
31937/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693576
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693575
31936/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693574
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693573
31935/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693572
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693571
31934/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693570
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693427
31851/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693426
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693425
31777/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693424
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693419
31764/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693418
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693655
31976/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693654
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693653
31975/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693652
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693651
31974/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693650
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693649
31973/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693648
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693647
31972/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693646
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693645
31971/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693644
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693641
31969/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693640
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693639
31968/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693638
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693637
31967/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693636
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693585
31941/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693584
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693583
31940/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693582
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693581
31939/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693580
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693579
31938/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693578
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693577
31937/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693576
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693575
31936/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693574
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693573
31935/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693572
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693571
31934/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693570
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693427
31851/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693426
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693425
31777/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693424
31740/ns_ge_classif
unix 3 [ ] STREAM CONNECTED 1693419
31764/postgres: pos /tmp/.s.PGSQL.5583
unix 3 [ ] STREAM CONNECTED 1693418
31740/ns_ge_classif
view thread (2+ messages) latest in thread
Message-ID: <469D0F99.1030002@aepnetworks.com>
Permalink: ../469D0F99.1030002@aepnetworks.com/
Also on: postgresql.org/message-id/469D0F99.1030002@aepnetworks.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: fei.liu@aepnetworks.com
Subject: Re: large number of connected connections to postgres database (v8.0)
In-Reply-To: <469D0F99.1030002@aepnetworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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