Re: very slow postgresql startup

Alex Ignatov <a.ignatov@xxxxxxxxxxxxxx> · Mon, 30 May 2016 19:29:15 +0300



    On 23.05.2016 11:33, 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.
      Many thanks
        in advance.
      

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

      
        ПП: Ако имаш идеи за сайт, виж какво предлагат СуперХостинг.БГ.
        Тази пролет дават -75% отстъпка за нов хостинг план.

      
    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