[ADMIN] Calculating size of the database tables

2004-06-10 Thread akuppachi
Hi, My application uses several database tables on Postgres backend and either a postgres or an ODBC front-end. I need to calculate the total hard disk space occupied by the database for my application. I started out by calculating the size of each record (row) in each table and multiplying th

Re: [ADMIN] Calculating size of the database tables

2004-06-10 Thread akuppachi
Hi, Thanks for the response. However, the README.dbsize says that "When computing the size of a table, it does not include TOAST or index disk space." So dbsize would not be giving me the total diskspace occupied by my tables, right ? I need to know the full disk space so i can do some hard di