Re: DB size - Mailing list pgsql-admin

From Grant
Subject Re: DB size
Date
Msg-id Pine.LNX.4.21.0108201016510.32148-100000@webster.conprojan.com.au
Whole thread Raw
In response to DB size  (Leandro Saad <leandro@ibnetwork.com.br>)
List pgsql-admin
> Hi all. I'm not a good DB admin , thats why I'm posting to this list !
> How can I figure out the size of a database or table ???

It was easier in older versions of postgresql to perform a `du -h` on
the directory that corresponded to the database name. However now they
are named by some type of object id?

Would it be possible for an item to be added to the to do list to perform
a report on a database?

I.e:

 \d{p|S|l|r}      list permissions/system tables/lobjects/ report

Report will contain:

1. Last vacuum time.
2. Space the database is using on the file system.
3. Some other juicy statistics?

Thanks.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange error message
Next
From: Grant
Date:
Subject: Re: [SQL] deleting large objects from jdbc