| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | liam saffioti <liam(dot)saffiotti(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL LO |
| Date: | 2022-04-17 00:04:57 |
| Message-ID: | c44210c7e6cf73d4c6f4547813ca2d0cf91dbca6.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ram Pratap Maurya | 2022-04-18 11:34:32 | Huge archive log generate in Postgresql-13 |
| Previous Message | liam saffioti | 2022-04-16 10:07:50 | PostgreSQL LO |