Re: pg_dump slower than pg_restore

From: David Wall <d(dot)wall(at)computer(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump slower than pg_restore
Date: 2014-07-03 23:54:18
Message-ID: 53B5ED2A.2040006@computer.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 7/3/2014 10:38 AM, Tim Clarke wrote:
> I'd also check the effect of those other run components; the vacuum's
> and other things that are only running with the backup and not during
> the restore.

The vacuumlo, vacuum and analyze run before the pg_dump. I am not
talking about any of the time they spend doing anything. What I am
measuring is the last modified timestamps of the 512MB split files only,
so if anything, I'm under-measuring by the time it takes to do the first
512MB segment.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-07-04 00:00:16 Re: pg_dump slower than pg_restore
Previous Message David Wall 2014-07-03 23:51:06 Re: pg_dump slower than pg_restore