writer process hangs???

From: "Andy" <frum(at)ar-sd(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: writer process hangs???
Date: 2005-07-21 10:21:01
Message-ID: 014f01c58ddd$e60b3470$0b00a8c0@forge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

These are my process lists for postgresql. I use 8.0.3.

The time for writer process seems a little big(928:49 >> that is around 15 H). Is this a thread? Is it normal to be running that long?

Best regards,
Andy.

postgres 2967 0.0 0.7 544504 8120 ? S May30 8:47 /usr/bin/postmaster -D /usr/local/pgsql/data
postgres 2969 1.2 49.7 545792 511864 ? S May30 928:49 postgres: writer process
postgres 2970 0.0 0.1 14876 1832 ? S May30 0:48 postgres: stats buffer process
postgres 2971 0.0 0.1 14064 1268 ? S May30 0:35 postgres: stats collector process
postgres 28321 0.0 2.3 548672 24620 ? S Jul07 1:16 postgres: slony mps 127.0.0.1(21684) idle
postgres 28326 0.0 2.0 549920 21456 ? S Jul07 0:56 postgres: slony mps 127.0.0.1(21685) idle
postgres 28327 0.0 31.7 549056 326000 ? S Jul07 0:44 postgres: slony mps 127.0.0.1(21686) idle
postgres 28328 0.0 3.7 549944 39012 ? S Jul07 2:48 postgres: slony mps_kd 127.0.0.1(21687) notify interrupt waiting
postgres 28329 0.0 2.0 547856 20780 ? S Jul07 8:12 postgres: slony mps 127.0.0.1(21688) idle
postgres 28332 0.0 3.3 548672 34552 ? S Jul07 1:18 postgres: slony mps_kd 127.0.0.1(21689) notify interrupt waiting
postgres 28337 0.0 20.2 550128 207684 ? D Jul07 3:09 postgres: slony mps_kd 127.0.0.1(21690) COMMIT
postgres 28338 0.0 2.5 549944 25864 ? S Jul07 2:51 postgres: slony mps 127.0.0.1(21691) idle
postgres 28339 0.0 6.3 549012 65436 ? S Jul07 0:40 postgres: slony mps_kd 127.0.0.1(21692) idle
postgres 28340 0.0 2.7 547856 28640 ? S Jul07 7:35 postgres: slony mps_kd 127.0.0.1(21693) idle
postgres 28342 0.0 2.5 547780 26604 ? S Jul07 1:47 postgres: slony mps 127.0.0.1(21694) idle
postgres 19215 0.0 3.2 546924 33636 ? S 12:31 0:00 postgres: postgres mps 127.0.0.1(27275) idle

Browse pgsql-admin by date

  From Date Subject
Next Message Palle Girgensohn 2005-07-21 12:24:16 mirror for gborg.postgresql.org?
Previous Message Tom Lane 2005-07-21 05:13:54 Re: FATAL: could not read statistics message