Schema sizes with large objects

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
********************************************************



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux