MIME-Version: 1.0
References: 
 <CAEphvJPSh1Cd+NA14Q3e-1B9JH6Ebm1oLgLx93HkkTZa=EBA_g@mail.gmail.com>
 <0137F599-5558-4B33-9533-94D9E28B7CC2@icloud.com>
 <CAEphvJPsxa5fsU0vFqdAz547URuho3HMZ=g1Sw75U09OOL=pDg@mail.gmail.com>
In-Reply-To: 
 <CAEphvJPsxa5fsU0vFqdAz547URuho3HMZ=g1Sw75U09OOL=pDg@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 16 Dec 2024 09:20:17 -0500
Message-ID: 
 <CANzqJaBefx4QaM_jOP1FkuNCA4iugFWukUGYnVG4vQXJ3i7yPg@mail.gmail.com>
Subject: Re: Performance
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e53c55062963e1e1"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaBefx4QaM_jOP1FkuNCA4iugFWukUGYnVG4vQXJ3i7yPg%40mail.gmail.com>
Precedence: bulk

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

On Mon, Dec 16, 2024 at 9:05=E2=80=AFAM Anex Hul <anexsql2014@gmail.com> wr=
ote:
[snip]

> 2. Are you truncating the table after each test run, or deleting all
> records, or appending?
>
> created new schema for each run.
>
> 3. Is the blob data stored in BYTEA column data, or are you using the
> (discouraged) "Large Objects"?
>
> Blob storage
>
Postgresql does not know what "Blob storage" means.


> 4. How are you loading the blob data?
>
> used the Import data using a COPY statement, followed this doc
>
>
> https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to=
-use-pg-azure-storage?tabs=3Dportal-01%2Cportal-02%2Cportal-03%2Cportal-04%=
2Cportal-05
>
If you're using a Microsoft extension, then you'd better ask Microsoft.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Dec 16, 2024 at 9:05=E2=80=AFAM A=
nex Hul &lt;<a href=3D"mailto:anexsql2014@gmail.com">anexsql2014@gmail.com<=
/a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><div>[=
snip]=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"><p dir=
=3D"ltr">2. Are you truncating the table after each test run, or deleting a=
ll records, or appending?</p>
<p dir=3D"ltr">created new schema for each run.<br></p>
<p dir=3D"ltr">3. Is the blob data stored in BYTEA column data, or are you =
using the (discouraged) &quot;Large Objects&quot;?</p>
<p dir=3D"ltr">Blob storage</p></blockquote><div>Postgresql does not know w=
hat &quot;Blob storage&quot; means.</div><div>=C2=A0</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"><p dir=3D"ltr"> </p>
<p dir=3D"ltr">4. How are you loading the blob data?<br></p>
<p dir=3D"ltr">used the Import data using a COPY statement, followed this d=
oc</p>
<p dir=3D"ltr"><a href=3D"https://learn.microsoft.com/en-us/azure/postgresq=
l/flexible-server/how-to-use-pg-azure-storage?tabs=3Dportal-01%2Cportal-02%=
2Cportal-03%2Cportal-04%2Cportal-05" target=3D"_blank">https://learn.micros=
oft.com/en-us/azure/postgresql/flexible-server/how-to-use-pg-azure-storage?=
tabs=3Dportal-01%2Cportal-02%2Cportal-03%2Cportal-04%2Cportal-05</a></p></b=
lockquote><div>If you&#39;re using a Microsoft=C2=A0extension, then you&#39=
;d better ask Microsoft.</div><div><br></div></div><span class=3D"gmail_sig=
nature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><di=
v dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t bo=
il me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></d=
iv></div></div></div></div>

--000000000000e53c55062963e1e1--