pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andy <frum@ar-sd.net>
To: pgsql-admin@postgresql.org
Subject: writer process hangs???
Date: Thu, 21 Jul 2005 13:21:01 +0300
Message-ID: <014f01c58ddd$e60b3470$0b00a8c0@forge> (raw)

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

Message-ID: <014f01c58ddd$e60b3470$0b00a8c0@forge>
Permalink:  ../014f01c58ddd$e60b3470$0b00a8c0@forge/
Also on:    postgresql.org/message-id/014f01c58ddd$e60b3470$0b00a8c0@forge

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: frum@ar-sd.net
  Subject: Re: writer process hangs???
  In-Reply-To: <014f01c58ddd$e60b3470$0b00a8c0@forge>
  References: <014f01c58ddd$e60b3470$0b00a8c0@forge>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox