X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 60635D9292 for ; Fri, 14 Oct 2005 11:09:09 -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 00799-06 for ; Fri, 14 Oct 2005 14:09:04 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id 06A6BD909B for ; Fri, 14 Oct 2005 11:09:05 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id C9C71234A1 for ; Fri, 14 Oct 2005 16:52:43 +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 04691-07 for ; Fri, 14 Oct 2005 16:52:42 +0300 (EEST) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id A08B1234A0 for ; Fri, 14 Oct 2005 16:52:42 +0300 (EEST) Message-ID: <030701c5d0c8$d2d3ce20$0b00a8c0@forge> From: "Andy" To: Subject: Postgres: writer process !? Time of process not to long??? Date: Fri, 14 Oct 2005 17:08:58 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0304_01C5D0E1.F7755CD0" 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.651 required=5 tests=[AWL=-0.352, FORGED_RCVD_HELO=0.05, HTML_50_60=0.095, HTML_MESSAGE=0.001, PLING_QUERY=0.857] X-Spam-Level: X-Archive-Number: 200510/165 X-Sequence-Number: 19237 This is a multi-part message in MIME format. ------=_NextPart_000_0304_01C5D0E1.F7755CD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 What exactly does the postgres: writer process ?? Only on one of the = servers the reported time of this process always rises very much(in this = example 32 Hours....) and the postgresql ist was restarted 2 days ago. I = find it odd, because I have this behavior only on one system. Is this = normal?=20 I have also a replication on one of the dbs.=20 ps aux | grep postgres postgres 2467 0.0 1.6 546624 17172 ? S Oct12 0:31 = /usr/bin/postmaster -D /usr/local/pgsql/data postgres 2516 1.1 48.1 547924 495324 ? S Oct12 32:49 postgres: = writer process =20 postgres 2517 0.0 0.2 16996 2740 ? S Oct12 0:02 postgres: = stats buffer process =20 postgres 2518 0.0 0.1 16188 1944 ? S Oct12 0:02 postgres: = stats collector process =20 postgres 3046 0.0 2.3 550892 23900 ? S Oct12 0:08 postgres: = slony mps 127.0.0.1(32771) idle =20 postgres 3053 0.0 2.2 552056 23048 ? S Oct12 0:06 postgres: = slony mps 127.0.0.1(32772) idle =20 postgres 3054 0.0 8.9 551176 92004 ? S Oct12 0:05 postgres: = slony mps 127.0.0.1(32773) idle =20 postgres 3055 0.0 2.2 549980 23024 ? S Oct12 0:40 postgres: = slony mps 127.0.0.1(32774) idle =20 postgres 3056 0.0 2.7 552052 27812 ? S Oct12 0:18 postgres: = slony mps_kd 127.0.0.1(32775) idle postgres 3058 0.0 2.5 550892 26148 ? S Oct12 0:08 postgres: = slony mps_kd 127.0.0.1(32776) idle postgres 3063 0.0 8.4 554060 86688 ? S Oct12 0:29 postgres: = slony mps_kd 127.0.0.1(32777) idle postgres 3064 0.0 2.3 552052 24668 ? S Oct12 0:19 postgres: = slony mps 127.0.0.1(32778) idle =20 postgres 3065 0.0 2.3 549980 24140 ? S Oct12 0:34 postgres: = slony mps_kd 127.0.0.1(32779) idle postgres 3066 0.0 3.3 551168 34348 ? S Oct12 0:05 postgres: = slony mps_kd 127.0.0.1(32780) idle postgres 3072 0.0 2.3 550056 24276 ? S Oct12 0:13 postgres: = slony mps 127.0.0.1(32783) idle =20 Regards,=20 Andy. ------=_NextPart_000_0304_01C5D0E1.F7755CD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
What exactly does the postgres: writer = process=20 ??  Only on one of the servers the reported time of this process = always=20 rises very much(in this example 32 Hours....) and the postgresql ist was = restarted 2 days ago. I find it odd, because I have this behavior only=20 on one system. Is this normal?
 
I have also a replication on one = of the dbs.=20
 
ps aux | grep postgres
 
postgres  2467  0.0  1.6 = 546624=20 17172 ?      S    = Oct12   0:31=20 /usr/bin/postmaster -D /usr/local/pgsql/data
postgres  = 2516  1.1=20 48.1 547924 495324 ?     S    = Oct12 =20 32:49 postgres: writer=20 process           =         =20
postgres  2517  0.0  0.2 16996 2740=20 ?        S   =20 Oct12   0:02 postgres: stats buffer=20 process           =   =20
postgres  2518  0.0  0.1 16188 1944=20 ?        S   =20 Oct12   0:02 postgres: stats collector=20 process          =20
postgres  3046  0.0  2.3 550892 23900=20 ?      S    Oct12   = 0:08=20 postgres: slony mps 127.0.0.1(32771) idle  
postgres  = 3053  0.0  2.2 552056 23048 ?     =20 S    Oct12   0:06 postgres: slony mps = 127.0.0.1(32772)=20 idle  
postgres  3054  0.0  8.9 551176 = 92004=20 ?      S    Oct12   = 0:05=20 postgres: slony mps 127.0.0.1(32773) idle  
postgres  = 3055  0.0  2.2 549980 23024 ?     =20 S    Oct12   0:40 postgres: slony mps = 127.0.0.1(32774)=20 idle  
postgres  3056  0.0  2.7 552052 = 27812=20 ?      S    Oct12   = 0:18=20 postgres: slony mps_kd 127.0.0.1(32775) idle
postgres  = 3058 =20 0.0  2.5 550892 26148 ?      = S   =20 Oct12   0:08 postgres: slony mps_kd 127.0.0.1(32776)=20 idle
postgres  3063  0.0  8.4 554060 86688=20 ?      S    Oct12   = 0:29=20 postgres: slony mps_kd 127.0.0.1(32777) idle
postgres  = 3064 =20 0.0  2.3 552052 24668 ?      = S   =20 Oct12   0:19 postgres: slony mps 127.0.0.1(32778) = idle  =20
postgres  3065  0.0  2.3 549980 24140=20 ?      S    Oct12   = 0:34=20 postgres: slony mps_kd 127.0.0.1(32779) idle
postgres  = 3066 =20 0.0  3.3 551168 34348 ?      = S   =20 Oct12   0:05 postgres: slony mps_kd 127.0.0.1(32780)=20 idle
postgres  3072  0.0  2.3 550056 24276=20 ?      S    Oct12   = 0:13=20 postgres: slony mps 127.0.0.1(32783) idle  
 
 
Regards,
Andy.
------=_NextPart_000_0304_01C5D0E1.F7755CD0--