Re: pg_dump slower than pg_restore - Mailing list pgsql-general

From David Wall
Subject Re: pg_dump slower than pg_restore
Date
Msg-id 53B5ED2A.2040006@computer.org
Whole thread Raw
In response to Re: pg_dump slower than pg_restore  (Tim Clarke <tim.clarke@manifest.co.uk>)
List 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.



pgsql-general by date:

Previous
From: David Wall
Date:
Subject: Re: pg_dump slower than pg_restore
Next
From: John R Pierce
Date:
Subject: Re: pg_dump slower than pg_restore