MIME-Version: 1.0
References: 
 <CAEZATCU_goy9GiN75Rhqwg8=AEHrujYdf+cF9ORMGg98Tc44YA@mail.gmail.com>
 <251A02BE-A148-4FEF-90EB-5E9559310B8E@dunslane.net>
In-Reply-To: <251A02BE-A148-4FEF-90EB-5E9559310B8E@dunslane.net>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Mon, 22 Jun 2026 17:30:59 +0200
Message-ID: 
 <CAFj8pRDbGis5SPwaoGjyeVd9K0ynabEXfe-C3RzOF+d46WLOyA@mail.gmail.com>
Subject: Re: Global temporary tables
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008048120654d956f3"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFj8pRDbGis5SPwaoGjyeVd9K0ynabEXfe-C3RzOF%2Bd46WLOyA%40mail.gmail.com>
Precedence: bulk

--0000000000008048120654d956f3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

po 22. 6. 2026 v 15:43 odes=C3=ADlatel Andrew Dunstan <andrew@dunslane.net>
napsal:

>
>
> > On Jun 22, 2026, at 4:57=E2=80=AFAM, Dean Rasheed <dean.a.rasheed@gmail=
.com>
> wrote:
> >
> > =EF=BB=BFOn Sun, 21 Jun 2026 at 23:06, Andrew Dunstan <andrew@dunslane.=
net>
> wrote:
> >>
> >> Wow, we're on the same track. I have a patch series for exactly this
> >> feature that I was about to submit.
> >>
> >> FTR here's where I'm at. I'll try to take a look at yours ASAP.
> >
> > Oh, wow. There's a lot of similarity between our patchsets, which is
> > reassuring, but there are also a number of differences, which I need
> > to think about in more detail.
>
> Yeah, agree on both fronts. The main areas I see are the catalog and
> handling wraparound. I don=E2=80=99t think there=E2=80=99s necessarily a =
clear winner on
> either, so I=E2=80=99ll be interested to hear what others say.
>

next week I'll have free time, I can check these patches

generally - global temporary tables is super useful for migration from
other systems

Regards

Pavel


>
> Cheers
>
> Andrew
>
>
>
>
>

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

<div dir=3D"ltr"><div>Hi</div><br><div class=3D"gmail_quote gmail_quote_con=
tainer"><div dir=3D"ltr" class=3D"gmail_attr">po 22. 6. 2026 v=C2=A015:43 o=
des=C3=ADlatel Andrew Dunstan &lt;<a href=3D"mailto:andrew@dunslane.net">an=
drew@dunslane.net</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex"><br>
<br>
&gt; On Jun 22, 2026, at 4:57=E2=80=AFAM, Dean Rasheed &lt;<a href=3D"mailt=
o:dean.a.rasheed@gmail.com" target=3D"_blank">dean.a.rasheed@gmail.com</a>&=
gt; wrote:<br>
&gt; <br>
&gt; =EF=BB=BFOn Sun, 21 Jun 2026 at 23:06, Andrew Dunstan &lt;<a href=3D"m=
ailto:andrew@dunslane.net" target=3D"_blank">andrew@dunslane.net</a>&gt; wr=
ote:<br>
&gt;&gt; <br>
&gt;&gt; Wow, we&#39;re on the same track. I have a patch series for exactl=
y this<br>
&gt;&gt; feature that I was about to submit.<br>
&gt;&gt; <br>
&gt;&gt; FTR here&#39;s where I&#39;m at. I&#39;ll try to take a look at yo=
urs ASAP.<br>
&gt; <br>
&gt; Oh, wow. There&#39;s a lot of similarity between our patchsets, which =
is<br>
&gt; reassuring, but there are also a number of differences, which I need<b=
r>
&gt; to think about in more detail.<br>
<br>
Yeah, agree on both fronts. The main areas I see are the catalog and handli=
ng wraparound. I don=E2=80=99t think there=E2=80=99s necessarily a clear wi=
nner on either, so I=E2=80=99ll be interested to hear what others say.<br><=
/blockquote><div><br></div><div>next week I&#39;ll have free time, I can ch=
eck these patches</div><div><br></div><div>generally - global temporary tab=
les is super useful for migration from other systems</div><div><br></div><d=
iv>Regards</div><div><br></div><div>Pavel</div><div>=C2=A0=C2=A0</div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex">
<br>
Cheers<br>
<br>
Andrew<br>
<br>
<br>
<br>
<br>
</blockquote></div></div>

--0000000000008048120654d956f3--