Re: Dangling large objects - Mailing list pgsql-general

From Tom Lane
Subject Re: Dangling large objects
Date
Msg-id 19636.978993369@sss.pgh.pa.us
Whole thread Raw
In response to Dangling large objects  (Adam Haberlach <adam@newsnipple.com>)
List pgsql-general
Adam Haberlach <adam@newsnipple.com> writes:
>     Is there any simple way for me to get a list of all large objects
> in a database, so I can see if there are actually rows referring to them
> and delete the ones that were not unlinked earlier?

Look at the vacuum_lo contrib module.

BTW, I believe lo_unlink doesn't need to be in a transaction block,
only lo_open/read/write/close do.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT INTO Troubles
Next
From: "Thomas T. Thai"
Date:
Subject: pgsql & mnogosearch