pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Laurenz Albe <laurenz.albe@cybertec.at>
To: soumik.bhattacharjee@kpn.com
To: ronljohnsonjr@gmail.com
To: pgsql-admin@lists.postgresql.org
Subject: Re: ERROR:::::: could not rename temporary statistics file ...
Date: Thu, 06 Jun 2019 16:34:27 +0200
Message-ID: <8d7ff53bef90672e4b7e557f8f9ceb5777998127.camel@cybertec.at> (raw)
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>

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

view thread (9+ messages)

Message-ID: <8d7ff53bef90672e4b7e557f8f9ceb5777998127.camel@cybertec.at>
Permalink:  ../8d7ff53bef90672e4b7e557f8f9ceb5777998127.camel@cybertec.at/
Also on:    postgresql.org/message-id/8d7ff53bef90672e4b7e557f8f9ceb5777998127.camel@cybertec.at

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, soumik.bhattacharjee@kpn.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: ERROR:::::: could not rename temporary statistics file ...
  In-Reply-To: <8d7ff53bef90672e4b7e557f8f9ceb5777998127.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox