Re: Postgres processes

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres processes
Date: 2003-03-10 16:35:35
Message-ID: m3n0k3ji20.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2003-03-10 16:53:33 Re: unlock Select for update
Previous Message Oleg Lebedev 2003-03-10 16:35:34 Postgres processes