Re: Postmaster processes running out of control?

On Wed, Mar 20, 2002 at 06:04:17PM -0500, Joshua Hoover wrote:
> I'm running PostgreSQL 7.1.3 on Red Hat Linux 7.1 and believe there is a
> problem with my PostgreSQL server.  I have a PHP application on a separate
> server accessing the PostgreSQL server.  The PostgreSQL server seems to be
> getting hammered, as even simple queries on indexed columns are taking
> FOREVER.  When I run top, here I normally see at least 50 entries similar to
> these for postmaster:
>
> 19336 postgres   9   0 92960  90M 92028 S     0.0  9.0   0:18 postmaster
> 19341 postgres   9   0 87996  85M 87140 S     0.0  8.5   0:09 postmaster
> 19355 postgres   9   0 87984  85M 87112 S    11.6  8.5   0:09 postmaster
> 19337 postgres   9   0 87952  85M 87092 S     0.0  8.5   0:09 postmaster

90MB per process? wow. Can you look in the server logs to see which query is
taking all the time?

I know PHP has persistant and non-persistant connections. I don't know what
criteria it uses to determine when the connection can be closed. Do you know
what your server is doing?

Lastly, is there a lot of disk activity?
--
Martijn van Oosterhout <kleptog@svana.org>   http://svana.org/kleptog/
> Ignorance continues to thrive when intelligent people choose to do
> nothing.  Speaking out against censorship and ignorance is the imperative
> of all intelligent people.