Bruce Momjian wrote:
> becks wrote:
> > hello.
> > how to check disk space usage for a single table?
> 
> Look at relpages in pg_class for that table.  VACUUM the table first.

Actually, I wrote some stuff up for the 7.3 docs on this:

        http://developer.postgresql.org/docs/postgres/diskusage.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to