Re: very slow postgresql startup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux