A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

New answers tagged

0

several hours seems a bit long for only 50gigs as other have stated. This tells us the IO on the server, or destination is bogged down or needs to be up-sized. Or this is network issue causing the slowness. I suggest do a pg_dump and monitor the server resources, hard-drive, and Network and the destination to see where slowness is Another option that ...


0

It depends a lot on details that you have not specified, particularly how the IO subsystem is arranged for this database instance. Single drive? Multiple? If multiple how is the data/uses spread over those drives? Drive types (spinning, SATA SSD, NVMe SSD, ..._)? Network rather than local and if net, what networking standards? With 50Gb taking "several ...


Top 50 recent answers are included