Skip site navigation (1) Skip section navigation (2)

From: Constantino Martins <const(at)med(dot)up(dot)pt>
To: pgsql-ports(at)postgresql(dot)org
Subject:
Date: 1999-11-16 03:36:44
Message-ID: 3.0.6.32.19991115193644.02cc9e80@mail.med.up.pt (view raw or flat)
Thread:
Lists: pgsql-ports
Dear Sir

Can you help me with a problem I have:

When  more than 30 process  query my Postgres data base, then my postmaster
create zombies process.
Like this:
USER       PID %CPU %MEM  SIZE   RSS TTY STAT START   TIME COMMAND
postgres  4139  0.1  0.0     0     0  ?  Z    18:38   0:01 (postmaster
<zombie>)
postgres  4140  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4141  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4142  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4143  0.1  0.0     0     0  ?  Z    18:38   0:01 (postmaster
<zombie>)
postgres  4146  0.1  0.0     0     0  ?  Z    18:38   0:02 (postmaster
<zombie>)
postgres  4150  0.1  0.0     0     0  ?  Z    18:38   0:02 (postmaster
<zombie>)
postgres  4152  0.1  0.0     0     0  ?  Z    18:38   0:02 (postmaster
<zombie>)
postgres  4159  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4170  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4174  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4175  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4177  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4178  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4179  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4194  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4195  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4197  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4199  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4200  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4201  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4202  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4203  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4204  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4205  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4206  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4209  0.0  0.0     0     0  ?  Z    18:38   0:00 (postmaster
<zombie>)
postgres  4597  0.0  0.9  1148   608  p4 S    18:52   0:00 bash 
postgres 11356  0.0  1.3  4816   824  ?  S   Nov 11   0:08
/usr/local/pgsql/bin/postmaster -B 256 -i -D /usr/local/pgsql/data
root         1  0.0  0.3   828   192  ?  S   Nov  9   0:05 init [3] 
root         2  0.0  0.0     0     0  ?  SW  Nov  9   0:00 (kflushd)
root         3  0.0  0.0     0     0  ?  SW< Nov  9   0:00 (kswapd)

I have a server with 64 MB.
Can you help me ?
thanks

sorry for my English

Atentamente e com os melhores cumprimentos

Constantino Martins




pgsql-ports by date

Next:From: Goda AttilaDate: 1999-11-16 09:51:12
Subject: NT Socket problem
Previous:From: SteveDate: 1999-11-16 03:24:11
Subject: Successful install, but I have a question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group