Re: PostgreSQL LO - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: PostgreSQL LO
Date
Msg-id c44210c7e6cf73d4c6f4547813ca2d0cf91dbca6.camel@cybertec.at
Whole thread Raw
In response to PostgreSQL LO  (liam saffioti <liam.saffiotti@gmail.com>)
List pgsql-admin
On Sat, 2022-04-16 at 13:07 +0300, liam saffioti wrote:
> 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.

You'll have to ask the people who created and used the database.

Yours,
Laurenz Albe




pgsql-admin by date:

Previous
From: liam saffioti
Date:
Subject: PostgreSQL LO
Next
From: Ram Pratap Maurya
Date:
Subject: Huge archive log generate in Postgresql-13