Date: Wed, 16 Oct 2024 23:48:47 +0200
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: Backup
Message-ID: <20241016214847.yzfvfkvfnnlm2ba3@hjp.at>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <CAEZv3cqct1WFb9KYmYa5kjdxfVK8JEFdzbJ5bRL6b4r+XR2dug@mail.gmail.com>
 <CANzqJaBfaOvbjJYYCPPC-JKFEw=pZTGkfwL3+-t2fjP7B_9U+g@mail.gmail.com>
 <f1a0c76b-c645-4530-b768-fea480eab56e@cloud.gatewaynet.com>
 <CANzqJaCtWGeLNoVVmzJ6=S6XzptR_K6VByCtwCLRVXAHUk0fUw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="hxjb722czvq44xdf"
Content-Disposition: inline
In-Reply-To: <CANzqJaCtWGeLNoVVmzJ6=S6XzptR_K6VByCtwCLRVXAHUk0fUw@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/20241016214847.yzfvfkvfnnlm2ba3%40hjp.at>
Precedence: bulk


--hxjb722czvq44xdf
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2024-10-16 16:02:24 -0400, Ron Johnson wrote:
> On Wed, Oct 16, 2024 at 4:00=E2=80=AFPM Achilleas Mantzios <
> a.mantzios@cloud.gatewaynet.com> wrote:
>     =CE=A3=CF=84=CE=B9=CF=82 16/10/24 22:55, =CE=BF/=CE=B7 Ron Johnson =
=CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
>         On Wed, Oct 16, 2024 at 3:37=E2=80=AFPM Andy Hartman <hartman60ho=
me@gmail.com>
>         wrote:
[...]
>=20
>         Step 1: redesign your DB to NOT=C2=A0use large objects.=C2=A0 It'=
s an old, slow
>         and unmaintained data type.=C2=A0 The data type is what you shoul=
d use.
>=20
>     You mean bytea I guess. As a side note, (not a fan of LOs), I had the
>     impression that certain drivers such as the JDBC support streaming fo=
r LOs
>     but not for bytea? It's been a while I haven't hit the docs tho.
>=20
>=20
> Our database is stuffed with images in bytea fields.=C2=A0 The Java appli=
cation uses
> JDBC and handles them just fine.

Images are usually small enough (a few MB) that they don't need to be
streamed.

I don't think bytea can be streamed in general. It's just like text, you
write and read the whole thing at once.

If you have data which is too large for that and want to store it in
bytea fields, you'll probably have to chunk it yourself (which you
probably have to anyway because for me "so large it has to be streamed"
implies "at least possibly larger than 1 GB").

        hp

--=20
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

--hxjb722czvq44xdf
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmcQNLgACgkQ8g5IURL+
KF2PRw//T9IC6acSOJ3qAjGDYg+uoyQNf8te2STKc71PUpSC5knJ+0eKasv7ue7I
GavlbNGJ+gNQzH3LgGjOpqjpMuRuYXuuedOffZj6Ea/w9KCsnT0CgzizqYwRQUPz
CXXTu5awfU4uRLZOAaLTMEpwrSI1b6qHPb/qNgzI7GtjbmrmOBJP7QmbQa6+rIzD
EQQpG4Byyzzj0o9iYaeqZlpp7ByOukA/xv1/OZUORokdXvLYJfoR+EZyDPqeLL/x
309BjsO1r6rK1aAQF9sl51GBlXbal+80PMwnL/yBjcP1/tfgkQC/pJnsl6edsQWE
A07zOz/TAt+t/fVpS163yCou2O1mQoFqQva87F/sXj19zJb5uGhSzP+B1yT0iZR6
uCR7ic7rFHPDT7RQOCadJYu9V4de1hsydQnqo1Wr+pVajU+1mMaUoGA+KKwtxlCJ
6gIZkepbUiIVO1vO9f2IqRi7B+k/0atCW5L+AXgI6Zktni9ujKBuECaYrNeuSdNk
uva3QtfkzpOCKWtZKqVUAsijAi0Dk6Fec+/ZYqDTLJpyDLXY2dbJ9QsrgsN52Bge
dBxSM94afGYsIzTRxpHbRt55Cj9FDiIJOvHWZK4V5gefVFY6J3pBktkwgUf9XUe7
hzkBC2fLPcI15vQx8r7cHkKp3/2/n+pmHT+O3vnG96VMwLTXM5w=
=RGfL
-----END PGP SIGNATURE-----

--hxjb722czvq44xdf--