Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b4lKr-0007gW-PK for pgsql-admin@arkaria.postgresql.org; Mon, 23 May 2016 08:35:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b4lKq-00037G-Pr for pgsql-admin@arkaria.postgresql.org; Mon, 23 May 2016 08:35:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b4lJ9-00019j-8S for pgsql-admin@postgresql.org; Mon, 23 May 2016 08:33:52 +0000 Received: from mx2.mail.bg ([193.201.172.118]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b4lJ5-0005F2-4k for pgsql-admin@postgresql.org; Mon, 23 May 2016 08:33:50 +0000 Received: from mail.bg (unknown [10.0.0.24]) by mx2.mail.bg (Postfix) with ESMTPA id 9D3DF60003AA for ; Mon, 23 May 2016 11:33:44 +0300 (EEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=mail.bg; s=default; t=1463992424; bh=m7zpibfgm8X3nkgdt9Dyi8Ls9mG8sEDKfMmV7/AuMNw=; h=Message-ID:Date:Subject:From:To:MIME-Version:Content-Type; b=ab1JLIXjrX+G9fJ6lZCQQFtOyJJV3arIt7uZ0hdZlrG7UyCHaAmiXPbQZ8kFYoSJC vOogai+WRVyuiO/+b/m1uw4vZM5ZnGb1xyNgBFSmFnU5jnU7dRKigpiXugIMJik3+/ SFs30ZBy3qGsWkcqmKUAnJDADXZz17rE6rjCE/18= Message-ID: <9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg> Date: Mon, 23 May 2016 08:33:44 -0000 Subject: very slow postgresql startup From: zz_11@mail.bg To: pgsql-admin@postgresql.org User-Agent: Mail.BG Webmail MIME-Version: 1.0 Content-Type: multipart/alternative;boundary="----=_20160523083344_99960" X-Priority: 3 (Normal) Importance: Normal X-Composed: 2016-05-23T08:33:44+00:00 X-Originating-IP: [94.156.95.6] X-Checking: 2016-05-23T08:33:44+00:00 X-Checked: 2016-05-23T08:33:44+00:00 X-Pg-Spam-Score: -3.9 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_20160523083344_99960 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable =0A=0A=0AHi,=0A=0A=0AAfter stopping my pg server with pg_ctl -m immediate s= top options it take=0Ahours to startup.=0A=0A=0AWith vmstat I find hi pcu a= nd io useages.=0A=0A=0AAny idea about this problem? I think it can be pg_xl= og files.=0A=0A=0AHow can I debug or trace this problem?=0A=0A=0Apg version= is 9.4.5 running on centos 6.=0A=0A=0AMany thanks in advance.=0A=0A=0A=0A= =0A-------------------------------------=0A=0A=D0=9F=D0=9F: =D0=90=D0=BA= =D0=BE =D0=B8=D0=BC=D0=B0=D1=88 =D0=B8=D0=B4=D0=B5=D0=B8 =D0=B7=D0=B0 = =D1=81=D0=B0=D0=B9=D1=82, =D0=B2=D0=B8=D0=B6 =D0=BA=D0=B0=D0=BA=D0=B2=D0= =BE =D0=BF=D1=80=D0=B5=D0=B4=D0=BB=D0=B0=D0=B3=D0=B0=D1=82 =D0=A1=D1=83= =D0=BF=D0=B5=D1=80=D0=A5=D0=BE=D1=81=D1=82=D0=B8=D0=BD=D0=B3.=D0=91=D0= =93. =D0=A2=D0=B0=D0=B7=D0=B8 =D0=BF=D1=80=D0=BE=D0=BB=D0=B5=D1=82 =D0= =B4=D0=B0=D0=B2=D0=B0=D1=82 -75% =D0=BE=D1=82=D1=81=D1=82=D1=8A=D0=BF=D0= =BA=D0=B0 =D0=B7=D0=B0 =D0=BD=D0=BE=D0=B2 =D1=85=D0=BE=D1=81=D1=82=D0=B8= =D0=BD=D0=B3 =D0=BF=D0=BB=D0=B0=D0=BD.=0A http://www.superhosting.bg/promo/= spring?utm_source=3DMailBG&utm_medium=3Dfooter&utm_content=3Dv1&utm_campaig= n=3DSpring2016 ------=_20160523083344_99960 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hi,


After stopping = my pg server with pg_ctl -m immediate stop options it take hours to st= artup.

With vmstat I find hi pcu= and io useages.

Any idea about = this problem? I think it can be pg_xlog files.

How can I debug or trace this problem?

pg version is 9.4.5 running on centos 6.

Many thanks in advance.




------------------------------= -------
= =0A=D0=9F=D0=9F: =D0=90=D0=BA=D0=BE =D0=B8=D0=BC=D0=B0=D1=88 =D0=B8=D0= =B4=D0=B5=D0=B8 =D0=B7=D0=B0 =D1=81=D0=B0=D0=B9=D1=82, =D0=B2=D0=B8=D0= =B6 =D0=BA=D0=B0=D0=BA=D0=B2=D0=BE =D0=BF=D1=80=D0=B5=D0=B4=D0=BB=D0=B0= =D0=B3=D0=B0=D1=82 =D0=A1=D1=83=D0=BF=D0=B5=D1=80=D0=A5=D0=BE=D1=81=D1= =82=D0=B8=D0=BD=D0=B3.=D0=91=D0=93. =D0=A2=D0=B0=D0=B7=D0=B8 =D0=BF=D1= =80=D0=BE=D0=BB=D0=B5=D1=82 =D0=B4=D0=B0=D0=B2=D0=B0=D1=82 -75% =D0=BE= =D1=82=D1=81=D1=82=D1=8A=D0=BF=D0=BA=D0=B0 =D0=B7=D0=B0 =D0=BD=D0=BE=D0= =B2 =D1=85=D0=BE=D1=81=D1=82=D0=B8=D0=BD=D0=B3 =D0=BF=D0=BB=D0=B0=D0=BD.=0A ------=_20160523083344_99960--