| From: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | ants(at)cybertec(dot)at |
| Cc: | hlinnakangas(at)vmware(dot)com, simon(at)2ndquadrant(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: 9.2.3 crashes during archive recovery |
| Date: | 2013-02-20 08:01:15 |
| Message-ID: | 20130220.170115.172246903.horiguchi.kyotaro@lab.ntt.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-02-20 08:11:18 | Re: Materialized views WIP patch |
| Previous Message | Kyotaro HORIGUCHI | 2013-02-20 07:51:02 | Re: Identity projection |