Postgres tablespace is cluster-wide. Therefore, how do I caculated how much space allocated by each database in postgres tablespace ?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Mar 8 '12 at 6:47
This question came from our site for professional and enthusiast programmers.
To get the disk space occupied by a database (nicely formatted):
Disk space occupied by a tablespace:
Find out more about database object size functions in the manual: