X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E036252AE6 for ; Thu, 21 Jul 2005 07:19:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21366-10 for ; Thu, 21 Jul 2005 10:18:52 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id 08EA252ACF for ; Thu, 21 Jul 2005 07:18:49 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 989472E6BA for ; Thu, 21 Jul 2005 13:10:13 +0300 (EEST) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13272-09 for ; Thu, 21 Jul 2005 13:10:12 +0300 (EEST) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 8510D2E69E for ; Thu, 21 Jul 2005 13:10:12 +0300 (EEST) Message-ID: <014f01c58ddd$e60b3470$0b00a8c0@forge> From: "Andy" To: Subject: writer process hangs??? Date: Thu, 21 Jul 2005 13:21:01 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_014C_01C58DF7.0A2C2170" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.279 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200507/171 X-Sequence-Number: 18227 This is a multi-part message in MIME format. ------=_NextPart_000_014C_01C58DF7.0A2C2170 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 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?=20 Best regards,=20 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 ------=_NextPart_000_014C_01C58DF7.0A2C2170 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
These are my process lists for = postgresql. I use=20 8.0.3.
 
The time for writer process seems a = little=20 big(928:49 >> that is around 15 H). Is this a thread? Is it normal = to be=20 running that long?
Best regards,
Andy.
 
postgres  2967  0.0  0.7 = 544504 8120=20 ?       S    = May30   8:47=20 /usr/bin/postmaster -D /usr/local/pgsql/data
postgres  = 2969  1.2=20 49.7 545792 511864 ?     S    May30 = 928:49=20 postgres: writer process
postgres  2970  0.0  0.1 = 14876 1832=20 ?        S   =20 May30   0:48 postgres: stats buffer process
postgres =20 2971  0.0  0.1 14064 1268 = ?       =20 S    May30   0:35 postgres: stats collector=20 process
postgres 28321  0.0  2.3 548672 24620=20 ?      S    Jul07   = 1:16=20 postgres: slony mps 127.0.0.1(21684) idle
postgres 28326  = 0.0  2.0=20 549920 21456 ?      S   =20 Jul07   0:56 postgres: slony mps 127.0.0.1(21685) = idle
postgres=20 28327  0.0 31.7 549056 326000 ?     = S   =20 Jul07   0:44 postgres: slony mps 127.0.0.1(21686) = idle
postgres=20 28328  0.0  3.7 549944 39012 ?     =20 S    Jul07   2:48 postgres: slony mps_kd=20 127.0.0.1(21687) notify interrupt waiting
postgres 28329  = 0.0  2.0=20 547856 20780 ?      S   =20 Jul07   8:12 postgres: slony mps 127.0.0.1(21688) = idle
postgres=20 28332  0.0  3.3 548672 34552 ?     =20 S    Jul07   1:18 postgres: slony mps_kd=20 127.0.0.1(21689) notify interrupt waiting
postgres 28337  0.0 = 20.2=20 550128 207684 ?     D    = Jul07  =20 3:09 postgres: slony mps_kd 127.0.0.1(21690) COMMIT
postgres = 28338 =20 0.0  2.5 549944 25864 ?      = S   =20 Jul07   2:51 postgres: slony mps 127.0.0.1(21691) = idle
postgres=20 28339  0.0  6.3 549012 65436 ?     =20 S    Jul07   0:40 postgres: slony mps_kd=20 127.0.0.1(21692) idle
postgres 28340  0.0  2.7 547856 28640 = ?      S    Jul07   = 7:35=20 postgres: slony mps_kd 127.0.0.1(21693) idle
postgres 28342  = 0.0 =20 2.5 547780 26604 ?      S   =20 Jul07   1:47 postgres: slony mps 127.0.0.1(21694) = idle
postgres=20 19215  0.0  3.2 546924 33636 ?     =20 S    12:31   0:00 postgres: postgres mps=20 127.0.0.1(27275) idle
------=_NextPart_000_014C_01C58DF7.0A2C2170--