Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b5WZS-0003pQ-IS for pgsql-admin@arkaria.postgresql.org; Wed, 25 May 2016 11:01:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b5WZS-0004f5-28 for pgsql-admin@arkaria.postgresql.org; Wed, 25 May 2016 11:01:50 +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 1b5WZR-0004eq-3d for pgsql-admin@postgresql.org; Wed, 25 May 2016 11:01:49 +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 1b5WZM-0002Sp-6v for pgsql-admin@postgresql.org; Wed, 25 May 2016 11:01:48 +0000 Received: from mail.bg (unknown [10.0.0.28]) by mx2.mail.bg (Postfix) with ESMTPA id 9CF4C6000377 for ; Wed, 25 May 2016 14:01:39 +0300 (EEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=mail.bg; s=default; t=1464174099; bh=X9KtgKQne04LAYrgEjIVEYZkCS5/lk9SQEufs5boHhI=; h=Message-ID:In-Reply-To:References:Date:Subject:From:To: MIME-Version:Content-Type; b=3+Gsg/lDa0oKWjvaTn2/QHefuIepaK5w/qUhWXVsxf3uAB4obJ3PFP9xDClex6GFw euJxXz0Uc3tVXB8MuL6hJYC1GxG22pVP273ahBH+UhdmY678gIF2Lx07S/SkPV36LE LpTNSsNmOe/4jJWqxhC/DTFRkNPkMHypGYKkg+os= Message-ID: In-Reply-To: <9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg> References: <9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg> Date: Wed, 25 May 2016 11:01:39 -0000 Subject: Re: 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="----=_20160525110139_41386" X-Priority: 3 (Normal) Importance: Normal X-Composed: 2016-05-25T11:01:39+00:00 X-Originating-IP: [94.156.95.6] 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 ------=_20160525110139_41386 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable =0A=0A=0AHi all,=0A=0A=0Aafter some investigation I found in pg database di= rectory many files=0Astarting with "t". For exmple:=0A=0A=0A-rw------- 1 po= stgres postgres 8192 May 25 11:13 t55_16771477=0A-rw------- 1 postgres post= gres 8192 May 25 08:12 t55_16771482=0A-rw------- 1 postgres postgres 8192 M= ay 25 09:07 t55_16771614=0A-rw------- 1 postgres postgres 8192 May 25 08:13= t55_16771632=0A-rw------- 1 postgres postgres 32768 May 25 07:05 t55_16772= 120=0A-rw------- 1 postgres postgres 24576 May 25 09:04 t55_16772120_fsm=0A= -rw------- 1 postgres postgres 8192 May 25 12:11 t55_16772129=0A-rw------- = 1 postgres postgres 0 May 25 08:40 t55_16772131=0A-rw------- 1 postgres pos= tgres 0 May 25 12:09 t55_16772285=0A-rw------- 1 postgres postgres 0 May 25= 09:44 t55_16772293=0A=0A=0ACan this one be the reason for slow pg start?= =0A=0A=0AMany thanks in advance,=0A=0A=0AIvan.=0A=0A=0A----- =D0=A6=D0= =B8=D1=82=D0=B0=D1=82 =D0=BE=D1=82 zz_11@mail.bg, =D0=BD=D0=B0 23.05.2016 = =D0=B2 10:33 ----- =0A=0A=0AHi,=0A=0A=0AAfter stopping my pg server with p= g_ctl -m immediate stop options it take=0Ahours to startup.=0A=0A=0AWith vm= stat I find hi pcu and io useages.=0A=0A=0AAny idea about this problem? I t= hink it can be pg_xlog 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 a= dvance.=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=0A=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=0A=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=0A=0A=0A=0A-------------= ------------------------=0A=0A=D0=9F=D0=9F: =D0=92=D0=B8=D0=B4=D1=8F =D0= =BB=D0=B8 =D1=81=D0=BF=D0=B5=D1=86=D0=B8=D0=B0=D0=BB=D0=BD=D0=B8=D1=82= =D0=B5 =D0=BF=D1=80=D0=B5=D0=B4=D0=BB=D0=BE=D0=B6=D0=B5=D0=BD=D0=B8=D1= =8F =D0=BD=D0=B0 =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=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, = =D1=82=D0=BE=D0=B2=D0=B0 =D0=B5 =D0=BF=D1=80=D0=B0=D0=B2=D0=B8=D0=BB=D0= =BD=D0=BE=D1=82=D0=BE =D0=BC=D1=8F=D1=81=D1=82=D0=BE!=0A http://www.superho= sting.bg/promo/spring?utm_source=3DMailBG&utm_medium=3Dfooter&utm_content= =3Dv2&utm_campaign=3DSpring2016 ------=_20160525110139_41386 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hi all,


after some= investigation I found in pg database directory many files starting with "t= ". For exmple:

-rw------- 1 post= gres postgres       8192 May 25 11:13 t55_16771477
-rw---= ---- 1 postgres postgres       8192 May 25 08:12 t55_1677148= 2
-rw------- 1 postgres postgres       8192 May 25 09:07 = t55_16771614
-rw------- 1 postgres postgres       8192 Ma= y 25 08:13 t55_16771632
-rw------- 1 postgres postgres     &nb= sp;32768 May 25 07:05 t55_16772120
-rw------- 1 postgres postgres  =    24576 May 25 09:04 t55_16772120_fsm
-rw------- 1 postgres = postgres       8192 May 25 12:11 t55_16772129
-rw------- = 1 postgres postgres          0 May 25 08:40 t55_16= 772131
-rw------- 1 postgres postgres          = 0 May 25 12:09 t55_16772285
-rw------- 1 postgres postgres    =      0 May 25 09:44 t55_16772293

Can this one be the reason for slow pg start?

<= p valid=3D"true" style=3D"line-height: 16px; font-size: 13px; font-family: = Tahoma, sans-serif; margin: 16px 0px;">

Many thanks in advance,

Ivan.


=0A

----= - =D0=A6=D0=B8=D1=82=D0=B0=D1=82 =D0=BE=D1=82 zz_11@mail.bg, =D0=BD=D0= =B0 23.05.2016 =D0=B2 10:33 -----

=0A
=0A

Hi,


After= stopping my pg server with pg_ctl -m immediate stop options it take h= ours to startup.

With vmstat I f= ind hi pcu and io useages.

Any i= dea 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
=0A

=0A

----------------------------------= ---
=0A= =D0=9F=D0=9F: =D0=92=D0=B8=D0=B4=D1=8F =D0=BB=D0=B8 =D1=81=D0=BF=D0=B5= =D1=86=D0=B8=D0=B0=D0=BB=D0=BD=D0=B8=D1=82=D0=B5 =D0=BF=D1=80=D0=B5=D0= =B4=D0=BB=D0=BE=D0=B6=D0=B5=D0=BD=D0=B8=D1=8F =D0=BD=D0=B0 =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=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, =D1=82=D0=BE=D0=B2=D0=B0 =D0= =B5 =D0=BF=D1=80=D0=B0=D0=B2=D0=B8=D0=BB=D0=BD=D0=BE=D1=82=D0=BE =D0=BC= =D1=8F=D1=81=D1=82=D0=BE!
=0A ------=_20160525110139_41386--