On 07/03/14 22:51, David Wall wrote: > > It just seems odd that pg_dump is slower than pg_restore to me. Most > grumblings I read about suggest that pg_restore is too slow. > > I have noted that the last split file segment will often appear to be > done -- no file modifications -- while pg_dump is still running, often > for another 20 minutes or so, and then some last bit is finally > written. It's as if pg_dump is calculating something at the end that is > quite slow. At startup, there's a delay before data is written, too, > but it's generally 1-2 minutes at most. Random thought: What OS & kernel are you running? Kernels between 3.2.x and 3.9.x were known to have IO scheduling issues. This was highlighted most by the kernel in Ubuntu 12.04 (precise) as shown here: <http://www.postgresql.org/message-id/50BF9247.2010800@xxxxxxxxxxxxxxxx> Bosco.
