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(at)svana(dot)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.