On Mon, 2023-06-12 at 13:48 +0000, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/15/datatype-binary.html
>
> When deleting a row that references (contains) a large object, I think that
> most users expect the DBMS to take care of the, now unreferenced, BLOB. It's
> good to know that PostgreSQL handles this differently and that one must
> periodically use vacuumlo to avoid BLOB data piling up. At least, that's
> what I understood.
>
> I think a small paragraph in the documentation about this would help many
> people. I can help with writing, if needed.
This is documented here:
https://www.postgresql.org/docs/current/lo.html
Admittedly, that is not the best place. Perhaps the introductory chapter
in https://www.postgresql.org/docs/current/lo-intro.html would be a good
place to mention that there is no referential integrity to large objects.
Yours,
Laurenz Albe