Re: [GENERAL] Working out diskspace taken by database and tables 7.4

2006-01-22 Thread Michael Fuhr
On Sun, Jan 22, 2006 at 12:53:57PM +, frank church wrote: > I am trying to work out how much space is taken up by a given > database in the file system. On Unix-like systems a simplistic way is to use "du" on the database directory, which is generally $PGDATA/base/database_oid. You can find t

[GENERAL] Working out diskspace taken by database and tables 7.4

2006-01-22 Thread frank church
I am trying to work out how much space is taken up by a given database in the file system. I have googled the archives and found the stuff there looks dated. Is there some script or query that can work it all out? My current version is 7.4. Knowing abut 8.x.x will be fine too? --