Re: Postgres processes

On Mon, 10 Mar 2003, Oleg Lebedev wrote:

> After running my application for a couple of days, I noticed that there
> is a bunch of postgres processes sitting on my system eating up a lot of
> memory. It show that they are all idle, but I don't know what started
> them. These processes use about 1GB of memory, so I will be really happy
> to get rid of them. But, why are they there? Any ideas?
> Thanks.

If your application is using persistant connections or connection pooling,
this is actually normal, and most of that memory being used is actually in
shared buffers, so no big deal.

If your application is NOT using persistant connections / pooling them,
then this is often a sign that your client side app is crashing.

Just do a 'pg_ctl -m immediate stop' ' pg_ctl start' to get rid of them
during off peak hours.