Re: very slow postgresql startup

From: "Vicky Soni - Quipment India" <vicky(dot)soni(at)quipment(dot)nl>
To: "zz_11(at)mail(dot)bg" <zz_11(at)mail(dot)bg>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: very slow postgresql startup
Date: 2016-05-25 11:04:06
Message-ID: 95cc35e427e6466d8f8b7dae8c62e283@Strand.quipment.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Can you please change log_min_message to debug2 and start service.

Check what postgresql is doing at start which takes time.

Also share some important lines from log file.

Thanks & Regards,
Vicky Soni
Database Administrator

From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of zz_11(at)mail(dot)bg
Sent: 25 May 2016 16:32
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] very slow postgresql startup

Hi all,

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

-rw------- 1 postgres postgres 8192 May 25 11:13 t55_16771477
-rw------- 1 postgres postgres 8192 May 25 08:12 t55_16771482
-rw------- 1 postgres postgres 8192 May 25 09:07 t55_16771614
-rw------- 1 postgres postgres 8192 May 25 08:13 t55_16771632
-rw------- 1 postgres postgres 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_16772131
-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?

Many thanks in advance,

Ivan.

----- Цитат от zz_11(at)mail(dot)bg<mailto:zz_11(at)mail(dot)bg>, на 23.05.2016 в 10:33 -----

Hi,

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

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.

-------------------------------------
ПП: Ако имаш идеи за сайт, виж какво предлагат СуперХостинг.БГ. Тази пролет дават -75% отстъпка за нов хостинг план.
<http://ads.mail.bg/delivery/ck.php?oaparams=2__bannerid=4132__zoneid=35__OXLCA=1__cb=ad4c2831cb__oadest=http%3A%2F%2Fwww.superhosting.bg%2Fpromo%2Fspring%3Futm_source%3DMailBG%26utm_medium%3Dfooter%26utm_content%3Dv1%26utm_campaign%3DSpring2016>

-------------------------------------
ПП: Видя ли специалните предложения на СуперХостинг.БГ? Ако имаш идеи за сайт, това е правилното място!
<http://ads.mail.bg/delivery/ck.php?oaparams=2__bannerid=4133__zoneid=35__OXLCA=1__cb=b98f26ba90__oadest=http%3A%2F%2Fwww.superhosting.bg%2Fpromo%2Fspring%3Futm_source%3DMailBG%26utm_medium%3Dfooter%26utm_content%3Dv2%26utm_campaign%3DSpring2016>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message bricklen 2016-05-25 16:01:45 Re: PITR Setup Using Hot StandBy
Previous Message zz_11 2016-05-25 11:01:39 Re: very slow postgresql startup