Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group