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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-ports by date

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