| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org,Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>,Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>,David Steele <david(at)pgmasters(dot)net>,Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>,Simon Riggs <simon(at)2ndquadrant(dot)com>,Craig Ringer <craig(at)2ndquadrant(dot)com>,Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>,Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>,Sokolov Yura <y(dot)sokolov(at)postgrespro(dot)ru>,Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>,Dmitry Dolgov <9erthalion6(at)gmail(dot)com>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>,PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] logical decoding of two-phase transactions |
| Date: | 2018-07-23 16:13:01 |
| Message-ID: | CC88AED5-9D79-4AEF-A66E-89A1EDF3AF17@anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On July 23, 2018 9:11:13 AM PDT, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>On Thu, Jul 19, 2018 at 3:42 PM, Andres Freund <andres(at)anarazel(dot)de>
>wrote:
>> I don't think this reasoning actually applies for making HOT pruning
>> weaker as necessary for decoding. The xmin horizon on catalog tables
>is
>> already pegged, which'd prevent similar problems.
>
>That sounds completely wrong to me. Setting the xmin horizon keeps
>tuples that are made dead by a committing transaction from being
>removed, but I don't think it will do anything to keep tuples that are
>made dead by an aborting transaction from being removed.
My point is that we could just make HTSV treat them as recently dead, without incurring the issues of the bug you referenced.
Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nico Williams | 2018-07-23 16:27:49 | Re: How can we submit code patches that implement our (pending) patents? |
| Previous Message | Tom Lane | 2018-07-23 16:12:30 | Re: Should contrib modules install .h files? |