> >> It is : postgres/8.3/main/base/16385/2613
>
> > This is a system catalog, pg_largeobject, which holds
> binary objects. If
> > you use Large Objects, no wonder this table could be really big.
>
> Also worth noting is that there's no automatic deletion mechanism for
> large objects. It could be that the space is being eaten by LOs that
> aren't referenced anymore. If so, you should think about applying
> contrib/lo and/or contrib/vacuumlo to manage your LOs.
>
Thanks a lot.
vacuumlo did the job. Indeed there were more the 100.000 orphaned LOs in
pg_largeobject.
We have to check how we can avoid this by using contrib/lo or in general
without using LOs.
One last question. After using vacuumlo the file size of 16385/2613 is
still the same as before.
It seems the content has been removed but the file itself hasn't been
compacted.
Is there an option or tool which can do this as well ?
Ciao Dirk.
DISCLAIMER:
Unless indicated otherwise, the information contained in this message is privileged and confidential, and is intended
onlyfor the use of the addressee(s) named above and others who have been specifically authorized to receive it. If you
arenot the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message
and/orattachments is strictly prohibited. The company accepts no liability for any damage caused by any virus
transmittedby this email. Furthermore, the company does not warrant a proper and complete transmission of this
information,nor does it accept liability for any delays. If you have received this message in error, please contact the
senderand delete the message. Thank you.
