MIME-Version: 1.0
References: <CAMLfE0MAVH5YORs0OKmD=fFWH9EtuNsnhViti=+hkp3Kbz-Gfw@mail.gmail.com>
 <CAHyXU0yrwoEYia0mZhpjQLMdd-WXpWFM+Au1jXQpk3MtBvdogw@mail.gmail.com>
 <CAMLfE0MWqALMJ99dpFniZ1xknCgHj4ETPWro+Ry9awPUG1OKMw@mail.gmail.com>
 <CAHyXU0y2gZfH_ZomazQB7H0KkuyV3QofvuvZcSYXEhpotG=hMA@mail.gmail.com>
 <CALL-XeM=0oH=2ECawmyCOv2umKF1nyqr97CuQXiPfO39uhCucQ@mail.gmail.com> <CANzqJaBvw-CAFyE+v2c91PBQazO0Y7sTP8gxqQh6XKDVv=8y+Q@mail.gmail.com>
In-Reply-To: <CANzqJaBvw-CAFyE+v2c91PBQazO0Y7sTP8gxqQh6XKDVv=8y+Q@mail.gmail.com>
From: Justin <zzzzz.graf@gmail.com>
Date: Tue, 9 Sep 2025 21:36:46 -0400
Message-ID: <CALL-XeNMYtzMK_VbJe40kXn0N0AQ2cLoR0RsOmpvAqJDOzbpPQ@mail.gmail.com>
Subject: Re: MVCC and all that...
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000dac784063e6874b1"
Archived-At: <https://www.postgresql.org/message-id/CALL-XeNMYtzMK_VbJe40kXn0N0AQ2cLoR0RsOmpvAqJDOzbpPQ%40mail.gmail.com>
Precedence: bulk

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

On Tue, Sep 9, 2025 at 9:12=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com=
> wrote:

> On Tue, Sep 9, 2025 at 8:41=E2=80=AFPM Justin <zzzzz.graf@gmail.com> wrot=
e:
>
>>
>> XID being 32 bit
>>
>
> Would converting them to 64 bits require changing the on-disk structure o=
f
> database files?
>

Yes this is one of the reasons 64 bit xid has not be used yet.  pg_upgrade
is not an option  as the database must be reloaded.


>
>
>> anonymous functions in PG have several limitation not just input
>> arguments (not sure i see the need for that)
>>
>
> Aren't transience and "ad hockery" the whole point of anonymous
> procedures?  Thus, I don't see the point of passing them parameters, eith=
er.
>

I agree.   It would be nice to be able to return a result.  I cheat using
RAISE NOTICE to get something back..


>
>
>> Temporary tables are a pain and cause issues for big databases
>>
>
> I'd like to see GLOBAL TEMPORARY tables.  Each connection gets its own
> private copy of the table, so that applications don't need to carry aroun=
d
> CREATE TEMPORARY TABLE code with them.
>
>
Temporary tables implementation is not optimal,  In most cases I am able to
remove temp tables with better SQL, that does not require intermediate temp
tables to hold result sets that are used later in the logic.  The SQL is
harder to write and understand .

Thanks
Justin

--000000000000dac784063e6874b1
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 g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Sep 9, =
2025 at 9:12=E2=80=AFPM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gma=
il.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Tue, =
Sep 9, 2025 at 8:41=E2=80=AFPM Justin &lt;<a href=3D"mailto:zzzzz.graf@gmai=
l.com" target=3D"_blank">zzzzz.graf@gmail.com</a>&gt; wrote:</div><div clas=
s=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div di=
r=3D"ltr"><div><br>XID being 32 bit=C2=A0<br></div></div></blockquote><div>=
<br></div><div>Would converting them to 64 bits require changing the on-dis=
k structure of database files?</div></div></div></blockquote><div>=C2=A0</d=
iv><div>Yes this is one of the reasons 64 bit xid has not be used yet.=C2=
=A0 pg_upgrade is not an option=C2=A0 as the database must be reloaded.=C2=
=A0</div><div>=C2=A0</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"=
><div dir=3D"ltr"><div class=3D"gmail_quote"><div>=C2=A0</div><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>anonymous functi=
ons in PG have several limitation not just input arguments=C2=A0(not sure i=
 see the need for that)=C2=A0<br></div></div></blockquote><div><br></div><d=
iv>Aren&#39;t transience and &quot;ad hockery&quot; the whole point of anon=
ymous procedures?=C2=A0 Thus, I don&#39;t see the point of passing them par=
ameters, either.</div></div></div></blockquote><div><br>I agree.=C2=A0 =C2=
=A0It would be nice to be able to return a result.=C2=A0 I cheat using RAIS=
E NOTICE to get something back..</div><div>=C2=A0</div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><=
div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><div>Temporary tables are a pain and cause issues for big database=
s<br></div></div></blockquote><div><br></div><div>I&#39;d like to see GLOBA=
L TEMPORARY tables.=C2=A0 Each connection gets its own private copy of the =
table, so that applications don&#39;t need to carry around CREATE TEMPORARY=
 TABLE code with them.</div><div><br></div></div></div></blockquote><div><b=
r></div><div>Temporary tables implementation is not optimal,=C2=A0 In most =
cases I am able to remove temp tables with better SQL, that does not requir=
e intermediate temp tables to hold result sets that=C2=A0are used later=C2=
=A0in the logic.=C2=A0 The SQL=C2=A0is harder to=C2=A0write and understand =
.=C2=A0=C2=A0</div><div>=C2=A0<br>Thanks=C2=A0</div><div>Justin</div></div>=
</div>

--000000000000dac784063e6874b1--