- Mailing list pgsql-hackers
From | Constantino Martins |
---|---|
Subject | |
Date | |
Msg-id | 3.0.6.32.19991115193604.02cc9e80@mail.med.up.pt Whole thread Raw |
List | pgsql-hackers |
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-hackers by date: