pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProcesses running without cleaning
2+ messages / 2 participants
[nested] [flat]
* Processes running without cleaning
@ 2008-02-18 13:00 Suresh Gupta VG <suresh.g@zensar.com>
2008-02-18 13:46 ` Re: Processes running without cleaning Tino Schwarze <postgresql@tisc.de>
0 siblings, 1 reply; 2+ messages in thread
From: Suresh Gupta VG @ 2008-02-18 13:00 UTC (permalink / raw)
To: pgsql-admin
Hi Team,
I am using Solaris9 and pgsql 8.2.5. Started the DB with the option 50
nodes and 100 blocks as below.
pg_ctl start -D /db1/postgresql/data -o "-N 50 -B 100 -i"
When started, there are 3 processes running with postgres names. After
that when a single transaction comes to the DB, it is going on
increasing it's number of processes by multiples of 3 or 4 up to the
peak connection say 53. Then when we open new session, it gives an error
that "psql : FATAL : Sorry, too many clients already".
Can you please any one explain, how the processes will go when we give
the options for blocks and nodes. As a common, we find 3 processes
running as parent processes of pgsql. Pls find the list of processes in
the attachment.(max_connction = 100 is configured in the postgresql
configuration file. Why cleaning up of process is not happening?
Pls advice.
Regards,
G. V. Suresh Gupta
------------------------------------------------------------------------
---------------------------------------------------------
Innovative Technology Solutions(ITS), Zensar Technologies
Zensar Knowledge Park, Plot#5, MIDC IT Tower,
Kharadi, Off Nagar Road, Pune - 411014
Landline : +91-20-66453471 | +91-9890898688
Email : suresh.g@zensar.com | website: www.zensar.com
DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails.
Attachments:
DB_processes.txt (text/plain, 6.0K) download
$ ps -ef |grep postgresql
pgsql 16378 14188 0 13:37:56 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 17032 16983 0 16:03:33 pts/3 0:00 grep postgresql
pgsql 16335 14188 0 13:26:04 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16333 14188 0 13:26:02 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16294 14188 0 13:17:00 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16321 14188 0 13:22:40 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16312 14188 0 13:19:14 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16295 14188 0 13:17:00 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16345 14188 0 13:31:08 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16336 14188 0 13:27:44 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16316 14188 0 13:20:56 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16337 14188 0 13:27:46 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16300 14188 0 13:17:34 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16329 14188 0 13:24:22 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16325 14188 0 13:24:20 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16340 14188 0 13:29:28 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16338 14188 0 13:27:46 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16315 14188 0 13:20:19 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16319 14188 0 13:22:38 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16317 14188 0 13:20:58 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16320 14188 0 13:22:40 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16339 14188 0 13:29:26 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16334 14188 0 13:26:04 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16318 14188 0 13:20:58 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16314 14188 0 13:19:16 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16328 14188 0 13:24:22 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16299 14188 0 13:17:34 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16298 14188 0 13:17:32 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16313 14188 0 13:19:16 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16457 14188 0 13:43:04 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16346 14188 0 13:31:10 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16348 14188 0 13:32:50 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16456 14188 0 13:43:02 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 14188 1 0 Feb 15 ? 0:01 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16347 14188 0 13:31:10 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16371 14188 0 13:36:14 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16369 14188 0 13:34:34 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16383 14188 0 13:39:40 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16349 14188 0 13:32:52 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16341 14188 0 13:29:28 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16372 14188 0 13:36:16 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16350 14188 0 13:32:52 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16373 14188 0 13:36:16 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16382 14188 0 13:39:40 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16368 14188 0 13:34:32 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16381 14188 0 13:39:38 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16370 14188 0 13:34:34 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16379 14188 0 13:37:58 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16380 14188 0 13:37:58 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16454 14188 0 13:41:22 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16453 14188 0 13:41:20 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
pgsql 16455 14188 0 13:41:22 ? 0:00 /db1/postgresql/bin/postgres -D /
db1/postgresql/data -N 50 -B 100 -i
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Processes running without cleaning
2008-02-18 13:00 Processes running without cleaning Suresh Gupta VG <suresh.g@zensar.com>
@ 2008-02-18 13:46 ` Tino Schwarze <postgresql@tisc.de>
0 siblings, 0 replies; 2+ messages in thread
From: Tino Schwarze @ 2008-02-18 13:46 UTC (permalink / raw)
To: pgsql-admin
On Mon, Feb 18, 2008 at 06:30:38PM +0530, Suresh Gupta VG wrote:
> Can you please any one explain, how the processes will go when we give
> the options for blocks and nodes. As a common, we find 3 processes
> running as parent processes of pgsql. Pls find the list of processes in
> the attachment.(max_connction = 100 is configured in the postgresql
> configuration file. Why cleaning up of process is not happening?
The processes will go away when the connection is closed, so it looks
like your application is not closing connections correctly.
HTH!
Tino.
PS: Rather than specifying -N and -B on command line, I would set the
appropiate options in postgresql.conf - max_connections and
shared_buffers.
--
www.craniosacralzentrum.de
www.spiritualdesign-chemnitz.de
www.forteego.de
Tino Schwarze * Lortzingstraße 21 * 09119 Chemnitz
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-02-18 13:46 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-18 13:00 Processes running without cleaning Suresh Gupta VG <suresh.g@zensar.com>
2008-02-18 13:46 ` Tino Schwarze <postgresql@tisc.de>
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