Admin details - disk space used

From: Simon Drabble <simon(at)eskimo(dot)com>
To: Postgres Group <pgsql-general(at)postgreSQL(dot)org>
Subject: Admin details - disk space used
Date: 1999-10-28 03:29:06
Message-ID: Pine.LNX.3.96.991027232458.9311G-100000@dragon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible somehow to get the space taken up by a database on disk? I know
I can get this as the postgres superuser but it's not particularly clear what
with system tables and stuff, and of course you have to be the postgres user
to do it.

It would be nice to be able to do something like

select diskspace();

and have it return the space taken up by each user table.

If this is a FAQ or in the docs somewhere feel free to flame away - I did look
but not terribly closely as the Braves are losing and I have to keep running
next door.

If it's not possible right now, is it planned? I might take a look at it
myself if it's not planned and other people are interested.

Simon.

--
"Linux - open doors, not windows."

Simon Drabble It's like karma for your brain.
simon(at)eskimo(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message omid omoomi 1999-10-28 04:08:39 Re: [GENERAL] A simple SQL command
Previous Message Brett W. McCoy 1999-10-27 20:21:24 Re: [GENERAL] foreign key