| From: | Grant <grant(at)conprojan(dot)com(dot)au> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: DB size |
| Date: | 2001-08-20 00:17:16 |
| Message-ID: | Pine.LNX.4.21.0108201016510.32148-100000@webster.conprojan.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grant | 2001-08-20 01:52:35 | Re: [SQL] deleting large objects from jdbc |
| Previous Message | Grant | 2001-08-20 00:11:48 | Re: DB size |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2001-08-20 01:12:01 | Re: Locale by default? |
| Previous Message | Grant | 2001-08-20 00:11:48 | Re: DB size |