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
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 |