Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYtTk-0004Gt-TX for pgsql-admin@arkaria.postgresql.org; Thu, 06 Jun 2019 14:34:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hYtTj-00051V-JR for pgsql-admin@arkaria.postgresql.org; Thu, 06 Jun 2019 14:34:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYtTj-00051O-7W for pgsql-admin@lists.postgresql.org; Thu, 06 Jun 2019 14:34:55 +0000 Received: from mx2.mailbox.org ([80.241.60.215]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYtTg-0004uH-D4 for pgsql-admin@lists.postgresql.org; Thu, 06 Jun 2019 14:34:53 +0000 Received: from smtp2.mailbox.org (smtp2.mailbox.org [80.241.60.241]) (using TLSv1.2 with cipher ECDHE-RSA-CHACHA20-POLY1305 (256/256 bits)) (No client certificate requested) by mx2.mailbox.org (Postfix) with ESMTPS id 77FF6A104F; Thu, 6 Jun 2019 16:34:49 +0200 (CEST) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp2.mailbox.org ([80.241.60.241]) by gerste.heinlein-support.de (gerste.heinlein-support.de [91.198.250.173]) (amavisd-new, port 10030) with ESMTP id h39gkAfmloNM; Thu, 6 Jun 2019 16:34:29 +0200 (CEST) Message-ID: <8d7ff53bef90672e4b7e557f8f9ceb5777998127.camel@cybertec.at> Subject: Re: ERROR:::::: could not rename temporary statistics file ... From: Laurenz Albe To: soumik.bhattacharjee@kpn.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org Date: Thu, 06 Jun 2019 16:34:27 +0200 In-Reply-To: <2A91BEF8171A5349931391E0C721CC534450D184@CPEMS-KPN501.KPNCNL.LOCAL> References: <2A91BEF8171A5349931391E0C721CC533D53302F@CPEMS-KPN301.KPNCNL.LOCAL> <7afa9150-e79e-b016-4618-d7df23211d62@gmail.com> <2A91BEF8171A5349931391E0C721CC5344508B6A@CPEMS-KPN501.KPNCNL.LOCAL> <6c314d1a-e662-af06-03a3-fc504a9702bb@gmail.com> <2A91BEF8171A5349931391E0C721CC534450D184@CPEMS-KPN501.KPNCNL.LOCAL> Organization: Cybertec Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk soumik.bhattacharjee@kpn.com wrote: > Please let me know if there is any performance improvements needed fort this restore? Its stuck here for last 2 days > > > My pg_restore is stuck here for last 2 days. > > > > pg_restore: creating CONSTRAINT "schema_name.num_servicenummer_historie snh_prx" > > Consuming CPU and disk IO, or just sitting there? > > Just sitting there and IO is more i think. > > Mem: 28380592K used, 33300260K free, 686312K shrd, 714616K buff, 6628188K cached > CPU: 4% usr 4% sys 0% nic 0% idle 90% io 0% irq 0% sirq 90% I/O-wait looks like the I/O subsystem has a problem. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com