Re: pg_dump slower than pg_restore

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@optionshouse.com>

Bosco.