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