Re: A Couple of Questions on Blobs - Mailing list pgsql-general

From Tom Lane
Subject Re: A Couple of Questions on Blobs
Date
Msg-id 14821.990632748@sss.pgh.pa.us
Whole thread Raw
In response to A Couple of Questions on Blobs  (Scott Holmes <sholmes@pacificnet.net>)
List pgsql-general
Scott Holmes  <sholmes@pacificnet.net> writes:
> First, I believe I probably have some orphan blobs in one of my
> databases.  I have updated some records, replacing one image oid with
> another before I knew about lo_unlink.  Is there a method for finding
> such stranded objects?

I think contrib/vacuumlo will help.

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Estimating costs (was Functional Indices)
Next
From: Bo Lorentsen
Date:
Subject: Re: Spliting a table/databases between several disks ?