Schema sizes with large objects

From: Daniel Rubio <drubio(at)oasi(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Schema sizes with large objects
Date: 2005-05-12 07:31:23
Message-ID: 4283064B.3040506@oasi.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
********************************************************

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Kichanov 2005-05-12 10:47:14 Incremental backup
Previous Message Tom Lane 2005-05-12 03:40:45 Re: thats funny :)