Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b7Q4E-00065o-Hd for pgsql-admin@arkaria.postgresql.org; Mon, 30 May 2016 16:29:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b7Q4E-0005Me-3g for pgsql-admin@arkaria.postgresql.org; Mon, 30 May 2016 16:29:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b7Q4D-0005L5-7S for pgsql-admin@postgresql.org; Mon, 30 May 2016 16:29:25 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b7Q47-0000YW-U0 for pgsql-admin@postgresql.org; Mon, 30 May 2016 16:29:24 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 3AC4421C8912; Mon, 30 May 2016 19:29:18 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id L5n1EIDruGoS; Mon, 30 May 2016 19:29:14 +0300 (MSK) Received: from [192.168.27.30] (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id AE45F21C88C7; Mon, 30 May 2016 19:29:14 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1464625754; bh=zjiWcT8NYI8Ch69JqUuuqeKU/CMAUgOWwj51afhxXaU=; h=Subject:To:References:From:Date:In-Reply-To; b=R1MitUabl342zP8r1KLfNtfnnue2vtfdW45/Ns1hd3IqvG7uA+Pdf8JzhjJ+44Sy+ Zl6EZvVQpluYBJIJmSevW9cNcJKllaoxU0I+e/RoodeD1LcOT6BWtJfrWQ7NZYQsqf lyKkHNmWHtqCrsCKr7d5Q2rj7bMD2R7OkWZX7BGs= Subject: Re: very slow postgresql startup To: zz_11@mail.bg, pgsql-admin@postgresql.org References: <9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg> From: Alex Ignatov Message-ID: <1ce91b2f-6509-3e56-a173-91392fc8141f@postgrespro.ru> Date: Mon, 30 May 2016 19:29:15 +0300 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.1.0 MIME-Version: 1.0 In-Reply-To: <9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg> Content-Type: multipart/alternative; boundary="------------68CA4676AB474ED983C1635B" X-Pg-Spam-Score: -3.4 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------68CA4676AB474ED983C1635B Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 23.05.2016 11:33, 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. > > 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 --------------68CA4676AB474ED983C1635B Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 

    
On 23.05.2016 11:33, 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.

      
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



    

  


--------------68CA4676AB474ED983C1635B--