Thanks so much fro the info.
I've done as you suggested and I've got the correct directories. I
have a second question now. There are forty-four numeric entries in
the directory for the first databases that I looked at. The database
in question has only eight tables. There are eight tables that have
recent dates. Do I need the total of all the files or just the eight
that appear to be the tables that are being updated?
Thanks again,
Carol
On Aug 1, 2007, at 9:25 AM, Chris Browne wrote:
walterc@xxxxxxxxxxx (Carol Walter) writes:
Is there a way to tell what the raw disk space used by a single
database is? I know that databases are fluid, but if there is way to
do even a snap shot view that is a "ball park" figure, I'd be happy.
My user keeps clammering for this figure.
Sure, you can identify the database via "select oid, * from
pg_catalog.pg_database;"
Then you should be able to head to $PGDATA (where ever the database
data lives), and run "du", and search for the directory whose name is
the "oid" value for the database that you wanted to analyze.
If users are using tablespaces, then tables can live in
user-controlled places, which would make it rather more complex to do
this analysis, but if they have kept to the simpler approach of just
letting data fall where it will, this should do the trick...
--
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://linuxfinances.info/info/linux.html
"High-level languages are a pretty good indicator that all else is
seldom equal." - Tim Bradshaw, comp.lang.lisp
---------------------------(end of
broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
