Finding out free space?

From: "Hans Guijt" <hg(at)terma(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Finding out free space?
Date: 2006-11-14 14:39:49
Message-ID: 000701c707fa$bd3209a0$ab14010a@nlpc17
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I need to provide an alarm function that will alert my customer when the
amount of free space in a database has reached some critical threshold. This
problem is not entirely trivial, since free space can be located both in the
file system and in the database itself.

I'm not looking for a particularly accurate function (and suspect that one
is probably not feasible anyway) - anything that comes to within a gigabyte
of the actual value is fine with me. Basically I need to figure out two
things:

1. Where does Postgres stores its datafiles? This will allow me to figure
out how much space is still available on the filing system.

2. How much space is unused within the data files themselves?

I'd appreciate a pointer on where I should look for this sort of
information.

Regards,

Hans Guijt

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2006-11-14 16:06:41 Re: validating incoming string length...
Previous Message Shane Ambler 2006-11-14 11:36:43 Re: Can somebody help me on adding so file