Re: Postgres processes - Mailing list pgsql-general

From Doug McNaught
Subject Re: Postgres processes
Date
Msg-id m3n0k3ji20.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Postgres processes  (Oleg Lebedev <oleg.lebedev@waterford.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Oleg Lebedev
Date:
Subject: Postgres processes
Next
From: Neil Conway
Date:
Subject: Re: unlock Select for update