Thread: writer process hangs???
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
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