From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | "Wood, Dan" <hexpert(at)amazon(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, pgsql-committers(at)postgresql(dot)org, "Wong, Yi Wen" <yiwong(at)amazon(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple |
Date: | 2017-12-15 01:00:29 |
Message-ID: | 20171215010029.3dxx56vjlymudvwo@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Hi,
On 2017-11-13 19:03:41 -0800, Andres Freund wrote:
> diff --git a/src/backend/access/heap/rewriteheap.c b/src/backend/access/heap/rewriteheap.c
> index f93c194e182..7d163c91379 100644
> --- a/src/backend/access/heap/rewriteheap.c
> +++ b/src/backend/access/heap/rewriteheap.c
> @@ -407,7 +407,10 @@ rewrite_heap_tuple(RewriteState state,
> * While we have our hands on the tuple, we may as well freeze any
> * eligible xmin or xmax, so that future VACUUM effort can be saved.
> */
> - heap_freeze_tuple(new_tuple->t_data, state->rs_freeze_xid,
> + heap_freeze_tuple(new_tuple->t_data,
> + state->rs_old_rel->rd_rel->relfrozenxid,
> + state->rs_old_rel->rd_rel->relminmxid,
> + state->rs_freeze_xid,
> state->rs_cutoff_multi);
Hm. So this requires backpatching the introduction of
RewriteStateData->rs_old_rel into 9.3, which in turn requires a new
argument to begin_heap_rewrite(). It originally was added in the
logical decoding commit (i.e. 9.4).
I'm fine with that, but it could theoretically cause issues for somebody
with an extension that calls begin_heap_rewrite() - which seems unlikely
and I couldn't find any that does so.
Does anybody have a problem with that?
Regards,
Andres
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2017-12-15 02:28:45 | pgsql: Fix pruning of locked and updated tuples. |
Previous Message | Tom Lane | 2017-12-14 22:19:39 | pgsql: Tighten configure's test for __builtin_constant_p(). |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2017-12-15 01:12:29 | Re: Top-N sorts verses parallelism |
Previous Message | Masahiko Sawada | 2017-12-15 00:51:38 | Re: [HACKERS] Assertion failure when the non-exclusive pg_stop_backup aborted. |