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

[Carol Walter <walterc@xxxxxxxxxxx>]

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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings