| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | soumik(dot)bhattacharjee(at)kpn(dot)com, ronljohnsonjr(at)gmail(dot)com, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: ERROR:::::: could not rename temporary statistics file ... |
| Date: | 2019-06-06 14:34:27 |
| Message-ID: | 8d7ff53bef90672e4b7e557f8f9ceb5777998127.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
soumik(dot)bhattacharjee(at)kpn(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mariel Cherkassky | 2019-06-08 15:21:14 | question regarding BUG #14999 |
| Previous Message | soumik.bhattacharjee | 2019-06-06 08:57:33 | RE: ERROR:::::: could not rename temporary statistics file ... |