What is the most accurate way of determining how much space is
currently being utilized by a table or index? I know about looking up
the relfilenode in pg_class and then doing a Unix "du -kcs" on the file
(and any related toast files), but I'm concerned that this will report
allocated-but-unused space as well as the space that is actually used.
Is there a better way?

Many thanks,...
Mike Dunham-Wilkie

begin mike (AT) barrodale (DOT) com wrote:
http://www.postgresql.org/docs/8.1/i...ons-admin.html

pg_relation_size(text):
Disk space used by the table or index with the specified name. The table
name may be qualified with a schema name.


end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°