Processes running without cleaning

"Suresh Gupta VG" <suresh.g@xxxxxxxxxx> · Mon, 18 Feb 2008 18:30:38 +0530

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@xxxxxxxxxx    | 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. 

$ 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings