Re: pg_dump slower than pg_restore

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: pg_dump slower than pg_restore
Дата
Msg-id 53B5ED2A.2040006@computer.org
обсуждение исходный текст
Ответ на Re: pg_dump slower than pg_restore  (Tim Clarke <tim.clarke@manifest.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: David Wall
Дата:
Сообщение: Re: pg_dump slower than pg_restore
Следующее
От: John R Pierce
Дата:
Сообщение: Re: pg_dump slower than pg_restore