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

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How much space do database objects take up in data files
Date: 2008-02-13 20:13:41
Message-ID: 96FC91B8-A568-4781-80D5-0319AA27E8A3@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-02-13 20:18:01 Re: CONTEXT messages for raise EXCEPTION
Previous Message paul socha 2008-02-13 19:37:55 Re: How much space do database objects take up in data files