Re: Postgres processes

Oleg Lebedev <oleg.lebedev@waterford.org> writes:

> 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?

Your application (or some other process) is holding Postgres
connections open instead of closing them when it's done.  If you
don't like it, fix the application.

-Doug