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
