Re: Large Database Restore

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Re: Large Database Restore
Дата
Msg-id 4abad0eb0705171449o34e9b48dyf11ade61d0eb3b1f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Large Database Restore  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: Large Database Restore  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general
I don't know if my database is typical (as there probably is no such thing), but to restore a full dump (pg_dumpall) takes over 4 hours on my backup server, but to restore a low level backup (about 35GB) and then process 145 WAL files (since Tuesday morning when the last low level backup was run) took me around 2 hours today
--
Mike Nolan


В списке pgsql-general по дате отправления:

Предыдущее
От: Glen Parker
Дата:
Сообщение: Re: Vacuum non-clustered tables only
Следующее
От: Reece Hart
Дата:
Сообщение: Re: Vacuum non-clustered tables only