Re: How much space do database objects take up in data files

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