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