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.
