Re: very slow postgresql startup

Hi,

Thank you.

Any idea how to view the progress?

Regards,

Ivan.

----- Цитат от Magnus Hagander (magnus(at)hagander(dot)net), на
23.05.2016 в 11:28 -----

On May 23, 2016 10:35, 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.

This is not uncommon when you shutdown with immediate. It's the main reason
you should normally use fast and not immediate.

And yes, it's likely the replay of xlog. Hours is a very long time though,
but with very high checkpoint timeout that's certainly possible.

/Magnus

Links:
------
[1] mailto:zz_11(at)mail(dot)bg

-------------------------------------

ПП: Видя ли специалните предложения на СуперХостинг.БГ? Ако имаш идеи за сайт, това е правилното място!
http://www.superhosting.bg/promo/spring?utm_source=MailBG&utm_medium=footer&utm_content=v2&utm_campaign=Spring2016