Re: How much space do database objects take up in data files - Mailing list pgsql-admin

From Carol Walter
Subject Re: How much space do database objects take up in data files
Date
Msg-id 96FC91B8-A568-4781-80D5-0319AA27E8A3@indiana.edu
Whole thread Raw
In response to How much space do database objects take up in data files  ("Peter Kovacs" <maxottovonstirlitz@gmail.com>)
Responses Re: How much space do database objects take up in data files  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-admin
Hi,

I've struggled with this one too.  You can get the size of databases
with SELECT pg_database_size('database name');  You can get the size
of tables with SELECT pg_relation_size('table name');

Carol
On Feb 13, 2008, at 1:43 PM, Peter Kovacs wrote:

> Hi,
>
> How can I find out how much space is taken up by database objects
> in data files?
>
> Thanks
> Peter
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq


pgsql-admin by date:

Previous
From: paul socha
Date:
Subject: Re: How much space do database objects take up in data files
Next
From: Tom Lane
Date:
Subject: Re: CONTEXT messages for raise EXCEPTION