public inbox for [email protected]  

help / color / mirror / Atom feed

PostgreSQL LO
2+ messages / 2 participants
[nested] [flat]

* PostgreSQL LO
@ 2022-04-16 10:07  liam saffioti <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: liam saffioti @ 2022-04-16 10:07 UTC (permalink / raw)
  To: pgsql-admin <[email protected]>

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PostgreSQL LO
@ 2022-04-17 00:04  Laurenz Albe <[email protected]>
  parent: liam saffioti <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Laurenz Albe @ 2022-04-17 00:04 UTC (permalink / raw)
  To: liam saffioti <[email protected]>; pgsql-admin <[email protected]>

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







^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2022-04-17 00:04 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-04-16 10:07 PostgreSQL LO liam saffioti <[email protected]>
2022-04-17 00:04 ` Laurenz Albe <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox