X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3DA3756379 for ; Thu, 12 May 2005 04:34:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86817-06 for ; Thu, 12 May 2005 07:34:17 +0000 (GMT) Received: from tinet.org (mail.tinet.org [195.77.216.130]) by svr1.postgresql.org (Postfix) with ESMTP id F3B7E56374 for ; Thu, 12 May 2005 04:34:10 -0300 (ADT) Received: (qmail 10376 invoked from network); 12 May 2005 07:34:08 -0000 Received: from serena.tinet.org (HELO oasi.org) ([194.224.210.4]) (envelope-sender ) by mail.tinet.org (SMTP OASI) with SMTP for ; 12 May 2005 07:34:08 -0000 Message-ID: <4283064B.3040506@oasi.org> Date: Thu, 12 May 2005 09:31:23 +0200 From: Daniel Rubio User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Schema sizes with large objects Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/219 X-Sequence-Number: 17648 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 ********************************************************