Re: 9.2.3 crashes during archive recovery

Поиск
Список
Период
Сортировка
От Kyotaro HORIGUCHI
Тема Re: 9.2.3 crashes during archive recovery
Дата
Msg-id 20130220.170115.172246903.horiguchi.kyotaro@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: 9.2.3 crashes during archive recovery  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Ответы Re: 9.2.3 crashes during archive recovery  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
Sorry, Let me correct a bit.

> I tried to postpone smgrtruncate after the next checkpoint. This

I tried to postpone smgrtruncate TO the next checktpoint.

> is similar to what hotstandby feedback does to vacuum.  It seems
> to be working fine but I warry that it might also bloats the
> table. I haven't found the way to postpone only objective
> smgrtruncate.
> 
> The patch below is a immediate verification patch for this
> solution.
> 
> - CreateCheckPoint records the oldest xmin at that point. Let's
>   call it 'checkpoint xmin'.
> 
> - vacuum skips the modification by the transactions at the same
>   time or after the checkpoint xmin.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Identity projection
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Materialized views WIP patch