soumik.bhattacharjee@xxxxxxx 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
