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 ???

-- 
Leandro Rodrigo Saad Cruz
InterBusiness tecn. e serv.
Sao Paulo - Brasil
Fri, 17 Aug 2001 14:32:05 -0300
Leandro Saad <leandro@ibnetwork.com.br>
DB size
> 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.


Mon, 20 Aug 2001 10:11:48 +1000 (EST)
Grant <grant@rawlinsons.com.au>
Re: DB size