MIME-Version: 1.0
References: <2ECBBCA0-4D8D-4841-8872-4A5BBDC063D2@amazon.com>
 <20210213162623.4upmsuzwv2anqoqx@alap3.anarazel.de>
 <BD1EADC5-C29D-4930-83DE-0F6D17C94636@amazon.com>
In-Reply-To: <BD1EADC5-C29D-4930-83DE-0F6D17C94636@amazon.com>
From: Ibrar Ahmed <ibrar.ahmad@gmail.com>
Date: Mon, 8 Mar 2021 23:14:56 +0500
Message-ID: 
 <CALtqXTc3UPuSLDKjihGdDiGdVVogg36CJ=REJ538bgQBL1ANqA@mail.gmail.com>
Subject: Re: partial heap only tuples
To: "Bossart, Nathan" <bossartn@amazon.com>
Cc: Andres Freund <andres@anarazel.de>,
	"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, "McAlister,
 Grant" <grant@amazon.com>,
	"Mlodgenski, Jim" <mlodj@amazon.com>, "Nasby, Jim" <nasbyj@amazon.com>, "Hsu,
 John" <hsuchen@amazon.com>,
	Bruce Momjian <bruce@momjian.us>
Content-Type: multipart/alternative; boundary="0000000000006f7d0505bd0a6bd4"
Archived-At: 
 <https://www.postgresql.org/message-id/CALtqXTc3UPuSLDKjihGdDiGdVVogg36CJ%3DREJ538bgQBL1ANqA%40mail.gmail.com>
Precedence: bulk

--0000000000006f7d0505bd0a6bd4
Content-Type: text/plain; charset="UTF-8"

On Wed, Feb 24, 2021 at 3:22 AM Bossart, Nathan <bossartn@amazon.com> wrote:

> On 2/10/21, 2:43 PM, "Bruce Momjian" <bruce@momjian.us> wrote:
> > I wonder if you should create a Postgres wiki page to document all of
> > this.  I agree PG 15 makes sense.  I would like to help with this if I
> > can.  I will need to study this email more later.
>
> I've started the wiki page for this:
>
>     https://wiki.postgresql.org/wiki/Partial_Heap_Only_Tuples
>
> Nathan
>
>
The regression test case  (partial-index) is failing

https://cirrus-ci.com/task/5310522716323840

----
=== ./src/test/isolation/output_iso/regression.diffs ===
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/partial-index.out
/tmp/cirrus-ci-build/src/test/isolation/output_iso/results/partial-index.out
--- /tmp/cirrus-ci-build/src/test/isolation/expected/partial-index.out
2021-03-06 23:11:08.018868833 +0000
+++
/tmp/cirrus-ci-build/src/test/isolation/output_iso/results/partial-index.out
2021-03-06 23:26:15.857027075 +0000
@@ -30,6 +30,8 @@
6 a 1
7 a 1
8 a 1
+9 a 2
+10 a 2
step c2: COMMIT;
starting permutation: rxy1 wx1 wy2 c1 rxy2 c2
@@ -83,6 +85,7 @@
6 a 1
7 a 1
8 a 1
+9 a 2
10 a 1
step c1: COMMIT;
----

Can you please take a look at that?

-- 
Ibrar Ahmed

--0000000000006f7d0505bd0a6bd4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Wed, Feb 24, 2021 at 3:22 AM Bossa=
rt, Nathan &lt;<a href=3D"mailto:bossartn@amazon.com">bossartn@amazon.com</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On=
 2/10/21, 2:43 PM, &quot;Bruce Momjian&quot; &lt;<a href=3D"mailto:bruce@mo=
mjian.us" target=3D"_blank">bruce@momjian.us</a>&gt; wrote:<br>
&gt; I wonder if you should create a Postgres wiki page to document all of<=
br>
&gt; this.=C2=A0 I agree PG 15 makes sense.=C2=A0 I would like to help with=
 this if I<br>
&gt; can.=C2=A0 I will need to study this email more later.<br>
<br>
I&#39;ve started the wiki page for this:<br>
<br>
=C2=A0 =C2=A0 <a href=3D"https://wiki.postgresql.org/wiki/Partial_Heap_Only=
_Tuples" rel=3D"noreferrer" target=3D"_blank">https://wiki.postgresql.org/w=
iki/Partial_Heap_Only_Tuples</a><br>
<br>
Nathan<br>
<br>
</blockquote></div><div><br></div>The regression test case=C2=A0 (partial-i=
ndex) is failing=C2=A0<br><br><a href=3D"https://cirrus-ci.com/task/5310522=
716323840">https://cirrus-ci.com/task/5310522716323840</a><div><br>----<br>=
<div>=3D=3D=3D ./src/test/isolation/output_iso/regression.diffs =3D=3D=3D<b=
r>diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/partial-index.o=
ut /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/partial-index=
.out<br>--- /tmp/cirrus-ci-build/src/test/isolation/expected/partial-index.=
out 2021-03-06 23:11:08.018868833 +0000<br>+++ /tmp/cirrus-ci-build/src/tes=
t/isolation/output_iso/results/partial-index.out 2021-03-06 23:26:15.857027=
075 +0000<br>@@ -30,6 +30,8 @@<br>6 a 1<br>7 a 1<br>8 a 1<br>+9 a 2<br>+10 =
a 2<br>step c2: COMMIT;<br>starting permutation: rxy1 wx1 wy2 c1 rxy2 c2<br=
>@@ -83,6 +85,7 @@<br>6 a 1<br>7 a 1<br>8 a 1<br>+9 a 2<br>10 a 1<br>step c=
1: COMMIT;<div>----</div><div><br></div><div>Can you please take a look at =
that?</div><div><br><div>-- <br><div dir=3D"ltr" class=3D"gmail_signature">=
<div dir=3D"ltr"><div>Ibrar Ahmed</div></div></div></div></div></div></div>=
</div>

--0000000000006f7d0505bd0a6bd4--