Обсуждение: Processes running without cleaning

Поиск
Список
Период
Сортировка

Processes running without cleaning

От
"Suresh Gupta VG"
Дата:

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.

Вложения

Re: Processes running without cleaning

От
Tino Schwarze
Дата:
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