Schema sizes with large objects

Поиск
Список
Период
Сортировка
От Daniel Rubio
Тема Schema sizes with large objects
Дата
Msg-id 4283064B.3040506@oasi.org
обсуждение исходный текст
Список pgsql-admin
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
********************************************************


В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: user specific limit for connections
Следующее
От: "Michael Kichanov"
Дата:
Сообщение: Incremental backup