Re: Connections, table locks, disk space

From: Haller Christoph <ch(at)rodos(dot)fzk(dot)de>
To: fabio3c(at)terra(dot)com(dot)br (=?iso-8859-1?Q?F=E1bio_Santana?=)
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Connections, table locks, disk space
Date: 2001-10-10 11:37:51
Message-ID: 200110100937.LAA05185@rodos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
I've done some research on your request,
but I could not find very much to help you.
What I've found about
1) Connections
http://www.postgresql.org/idocs/index.php?runtime-config.html
enable LOG_CONNECTIONS (boolean), LOG_PID (boolean)
to log database users
2) Table locks
nothing
3) Consumed disk space of a specific database
All database related files are located in
$PGDATA/base/<database-name>
So, by summing all file sizes within this
directory, you should have it.
As far as I know, the only limitation to a
database is given by the total disk capacity.

I hope this helps at least a bit.
I've looked through the FAQ list too, but
couldn't find anything which might help you.
Still, I don't understand why nobody else is
answering.
Regards, Christoph

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2001-10-10 12:52:54 Re: TOAST and TEXT
Previous Message Mike Mascari 2001-10-10 10:29:38 Re: Setting Password