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