Re: Slow PITR restore

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Slow PITR restore
Дата
Msg-id 47600C56.4020205@commandprompt.com
обсуждение исходный текст
Ответ на Re: Slow PITR restore  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Slow PITR restore
Список pgsql-general
Simon Riggs wrote:
> On Wed, 2007-12-12 at 07:36 -0800, Joshua D. Drake wrote:
>
>> We can't really expect people to use PITR if they new
>> it would take hours to recover even on the size of machine I was working on.
>
> That's not true statement in all cases and can often be improved with
> some monitoring and tuning. Just get your client to call me :-)
>

Uhh.. right.

> Are you doing replication, or a PITR for another reason?

Warm standby. Normally we pull every 5 minutes which is why we hadn't
noticed this before. However last night we pulled a full sync and
recover and that is when we noticed it.

8 seconds for a single archive recovery is very slow in consideration of
this machine. Even single threaded that seems slow.

Sincerely,

Joshua D. Drake



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

Предыдущее
От: "Douglas McNaught"
Дата:
Сообщение: Re: Would it be OK if I put db file on a ext2 filesystem?
Следующее
От: "David"
Дата:
Сообщение: General Q's