MIME-Version: 1.0
From: liam saffioti <liam.saffiotti@gmail.com>
Date: Sat, 16 Apr 2022 13:07:50 +0300
Message-ID: 
 <CAGHjuaaLXmjnKmhoHt7rjF0uxfzoWukuioL2pfmXxVAKS7Oveg@mail.gmail.com>
Subject: PostgreSQL LO
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d1f86505dcc2b39c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGHjuaaLXmjnKmhoHt7rjF0uxfzoWukuioL2pfmXxVAKS7Oveg%40mail.gmail.com>
Precedence: bulk

--000000000000d1f86505dcc2b39c
Content-Type: text/plain; charset="UTF-8"

Hi Team,

I wonder about the large objects in postgresql. I have a database in
PostgreSQL 12 and there are many large object records in pg_largeobjects.
But I don't know how it was created. Also, I guess all large objects are
orphaned because they will be removed when I run vacuumlo command with the
dry run option on the database.

How do I find out the reason for how these large objects were created?

Also, I don't have any binary data on the database tables.

Cheers,
Liam

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

<div dir=3D"ltr">Hi Team,<div><br></div><div>I wonder about the large objec=
ts in postgresql. I have a database in PostgreSQL 12 and there are many lar=
ge object records in pg_largeobjects. But I don&#39;t know how it was creat=
ed. Also, I guess all large objects are orphaned because they will be remov=
ed when I run vacuumlo command with the dry run option on the database.</di=
v><div><br></div><div>How do I find out the reason for how these large obje=
cts were created?</div><div><br></div><div>Also, I don&#39;t have any binar=
y data on the database tables.</div><div><br></div><div>Cheers,</div><div>L=
iam</div></div>

--000000000000d1f86505dcc2b39c--