Re: 9.2.3 crashes during archive recovery - Mailing list pgsql-hackers

From Kyotaro HORIGUCHI
Subject Re: 9.2.3 crashes during archive recovery
Date
Msg-id 20130220.170115.172246903.horiguchi.kyotaro@lab.ntt.co.jp
Whole thread Raw
In response to Re: 9.2.3 crashes during archive recovery  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Responses Re: 9.2.3 crashes during archive recovery  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List 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 by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Identity projection
Next
From: Tom Lane
Date:
Subject: Re: Materialized views WIP patch