Thread: writer process hangs???

writer process hangs???

From
"Andy"
Date:
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