Обсуждение: PostgreSQL LO

Поиск
Список
Период
Сортировка

PostgreSQL LO

От
liam saffioti
Дата:
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

Re: PostgreSQL LO

От
Laurenz Albe
Дата:
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