[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: postgresql database file names

Hash: SHA1

On 10/29/06 11:18, Tony Heal wrote:
> OK, how do you determine the disk size of a database. I have a var partition
> that is at 90% capacity and growing, and there are some databases I can
> remove, but it would be easier if I knew which DB's were taking up what disk
> space.

I don't think you can.  However, the postgresql-general list would
be helpful.  Also, the Postgresql docs are pretty thorough.  They
*might* point you to system tables that can help you write a script
to determine the info you want.

If you use v 8.1.x, tablespaces are the way to go.  Among other
things, they let you put each database (and schema and table and
index, if you'd like) in it's own subdirectory.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
Version: GnuPG v1.4.5 (GNU/Linux)


Reply to: