Re: very slow postgresql startup

On 23.05.2016 11:33, zz_11(at)mail(dot)bg wrote:
>
> 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>

Hi!
What do you see in strace output? I think that pg falls in unlinking
temp file from previous incarnation. Check this out or show us strace
output.
Thank you in advance.

Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company