Re: computing and updating the size of a table with large objects

On 8/31/07, Daniel Verite <daniel@manitou-mail.org> wrote:
>
> You can get the sizes from pg_largeobject, this way:
>
> SELECT id_doc, sum(length(data)) as filesize
> FROM documenti, pg_largeobject
> WHERE documenti.file = pg_largeobject.loid
> GROUP BY id_doc;
>
> --
>  Daniel
>  PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
>

Thanks a lot for the suggestion: I didn't think to use the
pg_largeobject: much cleaner, now :-)

Regards
Marco
--
Marco Bizzarri
http://iliveinpisa.blogspot.com/