
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




Mon, 15 Nov 1999 19:36:04 -0800
Constantino Martins <const@med.up.pt>