pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: Processes running without cleaning
Date: Mon, 18 Feb 2008 14:46:30 +0100
Message-ID: <20080218134630.GC23416@easy2.in-chemnitz.de> (raw)
In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0C4F0451@ZENMAILHQ1.ind.zensar.com>
References: <3D5445983859B84B92669C0D883EA6FB0C4F0451@ZENMAILHQ1.ind.zensar.com>

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



view thread (2+ messages)

Message-ID: <20080218134630.GC23416@easy2.in-chemnitz.de>
Permalink:  ../20080218134630.GC23416@easy2.in-chemnitz.de/
Also on:    postgresql.org/message-id/20080218134630.GC23416@easy2.in-chemnitz.de

 · 

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-admin@postgresql.org
  Cc: postgresql@tisc.de
  Subject: Re: Processes running without cleaning
  In-Reply-To: <20080218134630.GC23416@easy2.in-chemnitz.de>

* 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