Обсуждение: Schema sizes with large objects

Поиск
Список
Период
Сортировка

Schema sizes with large objects

От
Daniel Rubio
Дата:
Hi all

For auditory reasons, we need to report monthly the size of some of our
databases. We have been making it with database_size, but now we have a
database with diferent schemas for wich we need to know these sizes.

I've seen some functions here to do this, but we have a problem with the
large objects, because it seems that they're stored in a separate schema
(pg_catalog) and I can't find how to relate them with their schema in a
manner easy to make this operation.

Someone knows how I could do it?

--
********************************************************
Daniel Rubio Rodríguez
OASI (Organisme Autònom Per la Societat de la Informació)
c/ Assalt, 12
43003 - Tarragona
Tef.: 977.244.007 - Fax: 977.224.517
e-mail: drubio a oasi.org
********************************************************