Postgres Pro
Downloads
Home   >   mailing lists

Thread: disk space

disk space

From
becks@ultraviolence.org (becks)
Date:
hello.
how to check disk space usage for a single table?

Re: disk space

From
Bruce Momjian
Date:
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.

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

Re: disk space

From
Bruce Momjian
Date:
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
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026